I have been using the SharePoint List Source and Destination in SSIS 2008 for a while and I usually set the SiteUrl in the Advanced Editor as a predefined hyperlink of the site. However, I heard that we can set the SiteUrl with an expression/ variable so that I can control and change the variable of the data flow. May I know what the expression format is? I have tried @[User::SiteUrlVariable] (where "SiteUrlVariable" is a string variable storing the site url) but it fails saying something like UriFormat is invalid. Does anyone know what format I should use for the SiteUrl field? Thank you.

Hi YT Kwok, Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. Thanks, Lhan Han