In the 1st Execute SQL Task, the resultset is something like this:

Item

----

"Item1",

"Item2",

"Item3",

"Item4"

My version of SQL Server does not allow for the Concatenate function, so I figured I need to loop through the result set with the Foreach to build the string variable (like StringBuilder in C#) for the IN statement.

WHEELS