February 7, 2013 at 4:01 pm
Hi All,
I am new to SSIS and am currently working on a requirement as follows:
We have 30 sql scripts which queries various tables and gives the errors for each packages we have. We manually copy the script outputs to separate tabs in an excel sheet and send it to our clients. I am working on automating this using SSIS. So right now I have created a package which runs one sql script and writes to excel file tab. So to output 30 script results do I have to implement the above solution 30 times or is there any optimum way of implementing them?
Any suggestions would be welcome.
Thanks,
Athi.
February 12, 2013 at 9:56 am
What changes between the 30 scripts?
If it is just the table names then I would look for a ForEach loop solution.
February 13, 2013 at 6:56 am
This is a cross-post - no more answers here please - use this thread instead.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply