text files
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
Free Windows Admin Tool Kit Click here and download it now
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.
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 8:50pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics