SSIS Flat file to sqlserver
I have to import data from a flat file to table .
but each time the number of columns will vary in the flat file ,means some times we have to add dynamic columns to the table and
dump the data.
can any one help in this issue.
thanks and regrds,
Biru
August 3rd, 2012 3:27am
Hi Biru,
See id below post is useful
http://dwbi1.wordpress.com/2011/03/05/ssis-importing-a-file-with-dynamic-columns/- Chintak (My Blog)
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2012 3:37am