Where are you trying to set the SQL statement with the variable? In Expressions I don't see SQL Statement as an available property that you can set?

Tim

Denver, CO

Paul,

I tried the technique that was laid out in the knowledge base article. I did have a key that had the security issue. It was for a lexmark printer. Changed...

Wish I knew how I lost the enumerator. It was on my machine and functioning fine. Did some software installing of various things and some service packs. A few days...

I have had great results using Red Gate SQL Compare and SQL Data Compare products for this purpose. Definitely would suggest taking a look.

Normal disclaimer. No association with Red...

First I put a Foreach Loop Container on the Control Flow work surface by opening the toolbox and dragging the icon onto the work surface. Then I double click the...

I have the ForEach Loop container in my toolbox. What I am missing is the file enumerator in that container. I have tried removing the control from the toolbox and...