How can I create a ssis job to export tables to file

Question

Im new to ssis ,

I have a table like ↓

no  tablename
1    table1
2    table2
3    table3

what I want use ssis to do is ....

1, create a folder as name yyyyMMddhhmmss

2, fetch the table names from above table

3, export all the tables to files with their own name.

thanks for your help.

Answer 1

The basic pattern I would use would be to iterate through all the tables and invoke BCP against them.

Rough layout would be the following