Click here to Skip to main content
15,939,853 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

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.
Updated 3-Apr-19 9:13am

1 solution

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