SQL Integration Services

[timb94]

I'm new to SSIS but worked with DTS many year ago and need a little help.

I have five SQL tables in a database I need to transfer to five Excel spreadsheets (.xls). Each spreadsheet needs to have the same name as the SQL table. The tables all have the same layout.

I read on another web site that I would have to set up a table with the SQL table names and then loop through using IS to pull the information or something like that.

Would there be an easier way using SSIS to accomplish this? Any assistance would be appreciated.

Thank you
Tim

 

[djj55]

Please try forum

http://www.tek-tips.com/threadminder.cfm?pid=1555

for SSIS help

Good luck,

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[timb94]

Thanks djj55

I didn't know there was a forum for this topic.

I'll repost my question there.

Thanks again.