Click here to Skip to main content
14,880,336 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have multiple tables like Student,Department,Courses,Exam,Scores in a datbase.
I want to make a SSIS package which will extract this table to CSV files.
How do i get this table extracted to csv files using SSIS and using foreach loop container from a single package
Updated 14-Apr-15 8:00am
ZurdoDev 14-Apr-15 14:11pm
You don't need foreach. You can just do separate steps, one for each table.
abhishek6555 15-Apr-15 10:05am
So if i have 20 different tables do i have to create 20 dataflow task to extract those in 20 files
ZurdoDev 15-Apr-15 10:09am
Yes, if you want 20 different files. I'm sure there are other ways you could do it to. I haven't used SSIS in a long while.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900