March 17, 2009 at 10:49 am
I have 15 tables in a database (this could grow).
I want to put an SSIS package in place where I will move through these tables, outputting a fixed width flat file for each. Probably using a loop container of some sort.
Anyway my main questions are -
Has anyone done put together such a solution?
Is it wise to use SSIS in this way?
Should I just have a package for each output file and just put some time in doing this rather than automating the process completely as part of one package?
Be interested for some input.
Thanks
March 17, 2009 at 11:49 am
Seems like it would be very logical to implement the Foreach Loop Container. I would recommend looking around on Jamie Thompson's blog and finding examples and information that will help get you started like this posting - SSIS Nugget: Execute SQL Task into an object variable - Shred it with a Foreach loop.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 18, 2009 at 5:00 am
Thanks for the link. Lots of interesting stuff on there. Not found exactly what I need yet but I'll keep looking!
March 18, 2009 at 6:14 am
No problem. Jamie has tons of excellent content, examples, and downloads available to review in regards to SSIS and that is why he is an MVP:) He monitors the SSIS forums on MSDN also.
You might not find the exact sample that you need, but it should give you enough examples that will point you in the right direction and give you some ideas as to how you can go about creating a package to perform the task that you are trying to automate.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply