SSIS: Validation Error with Foreach Loop and Expression over Multiple Lists

Nov 26, 2009 at 3:15 PM

Hi,

I have multiple lists I want to iterate over using a Foreach Loop container.

I created  an expression in the data flow task to set [SharePoint List Source].[SiteListName] to @ListVariable.

In the [SharePoint List Source] the [SiteListName] field is empty after creating the expression (similar to using variables for the filename in the flat file tasks).

I get the following error. Package Validation Error

Error at Export Licenses from List on SAM SharePoint [SharePoint List Source]: SharePoint list name has not been set.
Error at Export Licenses from List on SAM SharePoint [SSIS.Pipeline]: "component "SharePoint List Source" (1)" failed validation and returned validation status "VS_ISBROKEN".

Error at Export Licenses from List on SAM SharePoint [SSIS.Pipeline]: One or more component failed validation.

Error at Export Licenses from List on SAM SharePoint: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

Any help is greatly appreciated!

Thanks,
Mike