Transfer different text file from a folder to different destinaton.

Apr 2, 2012 at 6:53 AM

Hi all,

I have all source files in one folder with different data (example text1.txt,text2.txt,text3.txt have same data fields than try1.txt,try2.txt have same data fields and all).
I need to combine each related file  and sent it into different SQL destination like text1 + text2 + text3 data should go to one SQL table and try1 + try2  should go to other SQL table.
Is it posible to complete this task in a single SSIS package?

Thanks in advance,


Apr 14, 2012 at 10:23 AM

If possible convert text file to csv....