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.
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