Thank you. I am on vacation this week, but 1st thing on Monday, I will try to implement.

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...

John Mitchell-245523 (3/6/2014)

---

You're making things too complicated. Your result set contains only one row, so change the result set to No Result Set and use output parameters in the...

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...

I have two Execute SQL tasks. The one for populating the variable. I have the variable in the ResultSet and the settign is Single Row. THe second Execute SQL task...

EricEyster (2/25/2014)

---

WheelsGuy (2/25/2014)

---

EricEyster (2/25/2014)

---

close.

the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct...

EricEyster (2/25/2014)

---

close.

the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct Input" and...

Getting closer. I set ResultSet to Single row, and I was able to add the variable in the Result Set section. In the Data Flow (OLE DB SOurce) I put...

EricEyster (2/24/2014)

---

I don't have a set of screen shots handy, but these are my normal steps:

1) create a SSIS variable

2) use a SQL task to query they first database

3) use...

Thank you. I really appreciate the assist. WHEELS