Set SiteListName from expression

Apr 17, 2012 at 6:48 PM

When trying to create a new list dynamically I have created an expression for sitelistname. When validated, I get "SiteListName has not been created". Anyone have the correct steps to set the SiteListName from a variable? I have set the expression from the DataFlow Task on NOT on the datasource itself. I have tried all combinations of expression usage I can think of. Thank you.


Apr 18, 2012 at 3:24 AM

Ah, I think I can understand why this is mixed up.  It is trying to validate the component but the site list name is not valid initially. Some options:

1) Create a default / template list to point your package at initially

2) Try using DelayValidation (think all dataflows have that property)

3) Move the SharepOint task into another Package and call the package from the parent package, that way the validation will happen when it is instantiated, which would be after you created your list.

Apr 18, 2012 at 4:18 PM

thx kevinidzi. I decided to put the whole task into one script task.

1. create SPSite list

2. get data (using SQLDataClient)

3. insert list items

4. set SP navigation prefs

5. done