Hi, I have 10 .txt files in my folder.I want pull the data into sql table. my requirement is 1) text1--->pull into sql table A(here Meta data is same) 2)text2---->pull into Sql table B(here also meta dat same) ----- ----------- like this plz let me know how can i develop package
October 19th, 2010 10:35am
if your metadata is same, you can use this link as a tutorial: http://plexussql.blogspot.com/2010/06/looping-through-csv-files-using-ssis.htmlhttp://www.rad.pasfu.com
October 19th, 2010 10:36am
metadata is same for all 10 files? if yes then you can use foreachloop and single DFT (single source and single destination with expression)for all file Else you have to create separate flow for all 10 files single DFT(10 sources and 10 destination). Let us TRY this | My Blog :: http://quest4gen.blogspot.com/
October 19th, 2010 10:40am
Hi If metadata is same then why do u want to put into seperate table. If it is single table you can create connection which handles multiple files.
October 22nd, 2010 8:50pm