loading text data into sql using foreach loop continer
Sure. But you need to check first which dataflow you need to use. I guess you can determine from the filename which structure it is? Put a script task before your 2 dataflows. Inside the script task, check the filename and set a variable accordingly. Connect the script task to the dataflows using 2 precedence constraints. Put an expression on each precedence constraints. For example: @WhichDataflow == 1MCTS, MCITP - Please mark posts as answered where appropriate.
April 25th, 2012 11:48am

Dear All, I have two textfile in my source folder i am able to load multiple text file with same strucure in sql using foreach loop container.in FOREACH LOOP CONTAINER i take one dataflow task where source is text and destination is sql created a variable which taking only text file my question s can i tale two dataflow task in foreach loop container to fetch dirrent structure text file. regards, Vipin jha
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2012 5:33am

Sure. But you need to check first which dataflow you need to use. I guess you can determine from the filename which structure it is? Put a script task before your 2 dataflows. Inside the script task, check the filename and set a variable accordingly. Connect the script task to the dataflows using 2 precedence constraints. Put an expression on each precedence constraints. For example: @WhichDataflow == 1MCTS, MCITP - Please mark posts as answered where appropriate.
May 13th, 2012 5:55am

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

Other recent topics Other recent topics