Setting SiteUrl won't work with an expression

May 3, 2012 at 5:43 PM
Edited May 3, 2012 at 5:57 PM


I'm trying to populate the SiteUrl from a variable that has been set based on a query to a SQL table that has a URL field.  Here are the steps I've taken and the result.

  1. Created a table with a url in it to reference a SharePoint Task List.
  2. Created a Execute SQL Task to grab the url putting the result set in a variable called SharePointUrl
  3. Created a For Each container and within the collection I use the SharePointUrl as the ADO object source variable and select rows in the first table.
  4. Still in the For Each container within the Variable mappings I have another Package Variable called PassSiteUrl2 and I set that to Index 0 or the value of the result set.
  5. I created a script task to then display the PassSiteUrl2 variable and it works great I see my url
  6. This is where it starts to suck eggs!!!!
  7. I insert a Data Flow Task into my foreach loop.
  8. I Insert a SharePoint List Adapter into my Data Flow
  9. Within my SharePoint List Adapter I set my list to be "Tasks", My list view to be "All Tasks" and then I set the url to be another SharePoint site that has a task list just so there is some default value to start with.
  10. Now within my Data Flow I create an expression and set the [SharePoint List Source].[SiteUrl] equal to my variable @[User::PassSiteUrl2].
  11. I save everything and run my SSIS package and it overlays the default [SharePoint List Source].[SiteUrl] with blanks in the SharePoint List Adapter then throws the error that its missing a url

So here is my question.  Why if my package variable displays fine in my Control Flow is it now not seen or seen as blanks in the Data Flow Expression.  Anyone have any ideas???



Nov 17, 2013 at 5:17 PM
Edited Nov 17, 2013 at 5:18 PM

i am facing the same issue for past one week. Did you resolve it ? If so please help me :(