October 1, 2008 at 4:42 am
I want to create a SSIS package which read and cleanse data from predefined text files at given path and bulk insert into Database table.
I need help for creating a task having For or For each loop in SSIS package to read, parse and insert data into table from text files one by one.
Please help me to identify, what are task i have to create and link them for above mentioned requirement?
October 1, 2008 at 7:16 am
Assuming the text files are all in the same location you can use a ForEach container and you would use the foreach file enumerator. You would place the file name in a variable and in your text file connection you would go to the expressions editor and set the ConnectionString to use your variable.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 5, 2008 at 7:17 am
I used above solution with Data Flow but i want to use Bulk Insert with For each loop.
do you know how can we do it?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply