Viewing 15 posts - 1 through 15 (of 16 total)
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...
June 24, 2010 at 1:27 pm
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. ...
June 17, 2010 at 9:59 am
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...
June 3, 2009 at 1:25 pm
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?
June 3, 2009 at 11:26 am
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...
April 14, 2009 at 2:59 pm
February 10, 2009 at 8:48 am
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...
July 17, 2008 at 7:10 am
I thought it was better to stay away from dynamic sql, which is why i did all the if statements.
July 17, 2008 at 6:11 am
May 30, 2008 at 1:59 pm
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,...
May 29, 2008 at 7:02 am
May 5, 2008 at 2:20 pm
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...
October 7, 2005 at 7:08 am
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...
April 12, 2005 at 9:40 am
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,...
April 11, 2005 at 1:34 pm
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.
March 25, 2005 at 8:43 am