Split the table data into multiple files

Database

Split the table data into multiple files

Hi All,

I have a requirement where I need to fast export the data using TPT and the exported data should split into multiple files based on date column.

e.g:

Table Data

1  abc 20150101

2  bcd  20150123

3 cde  20150205

4 def  20150421

The above data should split into 4 files

File_201501 :

1  abc 20150101

2  bcd  20150123

File_201502 :

3 cde  20150205

File_201504 :

4 def  20150421

Can anyone please help on this.

Thanks in Adv.

Regards,

Lalitha