Iterate the task
HI Experts, Am completely new to SSIS.I have a scenario here. Suppose if there some exception in my task(suppose script component),It should again go back to script component and execute that until the count has reached 5. How can i do it.needed urgently plz
April 12th, 2011 2:03am

Is this in the dataflow or in the control flow? For starters, check out the for loop container and the precedence constraints in the control flow.MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 2:06am

You can use for loop container to execute a task multiple times. Script component is part of data flow task and it is not possible to execute a script component without executing the whole data flow task. So, you have to execute the data flow task 5 times in order to execute the script component 5 times.Nitesh Rai- Please mark the post as answered if it answers your question
April 12th, 2011 2:12am

Control flow.
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 2:12am

Control flow. Allright, then use the for loop container combined with the precedence constraints: if the script task fails, redirect with a red arrow to a for loop container that executes a copy of the same script task 5 times.MCTS, MCITP - Please mark posts as answered where appropriate.
April 12th, 2011 2:17am

I'm not clear about your question. could you bring a sample? do you want to iterate through data rows and do some action? if yes, you can use data flow transformation for this. please bring a clarifying sample.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 2:17am

Perfect, I got the solution.Thanks Koen.
April 12th, 2011 2:21am

HI Raad, here i will intentionally fail the script component and after that it has to iterate some 5 times through the same script component. I just followed Koen solution above. Thanks
Free Windows Admin Tool Kit Click here and download it now
April 12th, 2011 2:23am

That's OK. Just note that Script Component is a transformation in data flow task. but Script Task is a task in control flow. Note this terminology when talk about scripting in SSIS.http://www.rad.pasfu.com
April 12th, 2011 2:34am

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

Other recent topics Other recent topics