I have the 1st Execute SQL Task pulling a list of items (separated by commas). I have the resultSet set to Single Row, 0 in the Result Name, and the variable in the Variable Name. The output goes into a For Each Container, the Enumerator is set to Foreach ADO Enumerator. The ADO object source varaiable is the item, Rows in the first table is selected, I put the varaiable in the Variable Mapping with a 0 index, and in the expression under Foreach emulator the variable name is listed. The output goes into the secong Execute SQL Task (all in the Control Flow). In the parameter mapping I set the variable name, Input, VARCHAR, parameter name (should it be 0 instead?), and -1. I am receiving an error:

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Foreach Loop Container: The result of the expression "@[User::MyItem]" on property "ForEachEnumerator" cannot be written to the property. The expression was evaluated, but cannot be set on the property.

Error at Data Flow Task [OLE DB Command [1331]]: Parameters are not bound. All parameters in the SQL command must be bound to input columns.

Error at Data Flow Task [SSIS.Pipeline]: "component "OLE DB Command" (1331)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

BUTTONS:

OK

------------------------------