Create multiple flat files in SSIS to export data from a table on a daily basis.

See more:

SSIS

Hi,

I want to export data to multiple flat files on a daily basis which will just push data from table to flat file in comma delimeter.

Also the files which are getting created will must be named as Test_Load_DDMMYY.

So there would be 30 files created in a month if the month consists of 30 days.

What I have tried:

I tried using OLEDB source and pushed data to flat file.

For creating filename in the concerned format I used expressions.

I am unable to create multiple files on daily basis.

If I am able to create multiple files then i just need to schedule the package in a job.