July 25, 2018 at 2:24 pm
I am trying to pass the name of the next step to variable the current step.
For Example, I want to pass the name of "Data Flow Task B" to Task A. I am using this variable to determine if on a restart, Data Flow Task B as been run successfully, so it can be skipped to task C
Task A ----> Data Flow Task B---->Task C
July 25, 2018 at 2:33 pm
If you use SSIS's checkpoint files it will automatically start at the step that's failed.
https://www.mssqltips.com/sqlservertip/1408/integration-services-checkpoints-to-restart-package-from-failure/
July 25, 2018 at 2:50 pm
Sorry I should have clarified
there are multiple Data flow tasks the run in parallel in the sequence container so check pointing would be unreliable:
Task A -->Data Flow B-->Task C
Task D-->Data Flow E--> Task F
Task G--> Data Flow H --> Task I
ECT...
July 25, 2018 at 3:05 pm
I think you might find it easier to set up a table which logs progress for each execution and then use that to drive subsequent executions.
Would require some design and setting up, but should work.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply