sql server 2008 - SSIS Text file destination with a custom defined formatting -

sql server 2008 - SSIS Text file destination with a custom defined formatting -

i trying create file custom formatting destination text file. not sure if can done without creating custom transformation.

example:

i have next table:

date companyname companyaddress phone amountinwords amount 12/16/2011 abc company def street, fremont, ca 12345 1234567891 2 hundred 200 11/11/2013 xyz company tuv street, fremont, ca 12346 9087654321 5 hundred 500

and expecting result in below format:

12/16/2011 abc company def street, fremont, ca 12345 1234567891 2 hundred 200 ------------------------------------------------------------------------------------ 11/11/2013 xyz company tuv street, fremont, ca 12346 9087654321 5 hundred 500 ------------------------------------------------------------------------------------

it seems need utilize script task, , write custom script generate required data.

the logic script task - read file line line , set logic format info per requirement.

follow this question, it's same yours, have reverse process.

sql-server-2008 tsql ssis msbi