June 9, 2011 at 4:06 pm
Hello,
I have an existing DTS job in SQL 2000, which I need to convert to SSIS 2008. The existing DTS package
has executes the a package three times with different parameters and create three different files.
When I am creating the same in SSIS, I am facing a problem. I have created three data flows and extract destination files. The first step executes, but the next one error outs. The result set retrieved from the SP all three times have different set of columns. I am assuming as the columns are different which could be the reason.
Also when I am seeing the properties of the second extract files, it shows the columns for step 1.
Please help!
June 9, 2011 at 5:48 pm
What is the error?
June 10, 2011 at 7:40 am
Hello, the second batch also takes by default the first set of collumns.
June 10, 2011 at 8:00 am
This was removed by the editor as SPAM
June 10, 2011 at 8:06 am
This was removed by the editor as SPAM
June 10, 2011 at 9:10 am
Hello,
As per your suggestion adding the code SET FMTONLY OFF in the SP did resolve my problem thanks a lot.
Also do you have an example stating how can I use For each loop so that instead of having three source and destination in the package, I can have just one source and destination to generate three csv files?
June 13, 2011 at 12:32 am
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply