I found your post today because I was searching for a solution to the exact same problem. I can view the data in my report in BIDS but there...

Hi Eric -

My post was so long ago, that I barely remember the problem. I don't recall that I ever figured out the answer to my question. ...

Thank you. I actually ended up using System.IO to loop through the files inside a script task and copy them - similar to what I was used to doing...

Thanks very much. I did find a good example here - http://rafael-salas.blogspot.com/2009/05/ssis-foreach-loop-looping-through.html

Inside the for each container, can the enumerator configuration folder be set to a variable?

There is probably a more elegant way to do this, but this is what I ended up using, and it works for my report. Inside the script task I...

Thank you!

I wasn't sure if the execution plan would be reused or not, but was suspicious that it might not be. Thanks for your explanation and the suggestion for using...

I thought it was better to stay away from dynamic sql, which is why i did all the if statements.

Thank you!

There are about 12 different flatfile connections in addition to an odbc connection. I would like to rename each text file when the package is run - for example,...

Thank you.

I opened this article because I "knew I should" but wasn't really looking forward to it. Sometimes these kinds of articles get dull and then very confusing (probably because I'm...

Thank you all for your advice.  Part of the problem is that we ran out of disk space, so I don't have enough room to save to another table the data...

Thank you.  The recovery mode is set to simple, but it's still filling up.  I will probably try Jim P's suggestion to save off the rows I want to keep,...

I'm writing for the same reason as Tim.  I too am a silent but daily reader of your editorials.   Good luck with the barn.