SSIS 2014 - Repeating a SQL Task one time in the control flow..What task combinations/components would I use?
I have 5 SSIS SQL tasks,
I want it to flow like this Execute Sql Task 1
Execute Sql Task 2
Execute Sql Task 3
Execute Sql Task 4
Execute Sql Task 3
Execute Sql Task 5
What task structures and containters would I use?
I want it to flow like this Execute Sql Task 1
Execute Sql Task 2
Execute Sql Task 3
Execute Sql Task 4
Execute Sql Task 3
Execute Sql Task 5
What task structures and containters would I use?
YZlat
What kind of tasks are these? If SQL statements, you can use execute SQL. In order to execute your tasks sequentially you can use a sequence container and drag and drop all your tasks in there
Correct, multiple 'Execute SQL Task's. If there's any additional requirements that you have and would like answers on, then you'll need to provide us more details.
Are these common enough that they can be put into a loop? Does this order change based on certain conditions? Want a message to say when it's done, it blows up?
Are these common enough that they can be put into a loop? Does this order change based on certain conditions? Want a message to say when it's done, it blows up?
ASKER
These are stored procedures with in each task that do a large amount of heavy processing. The above chain is contingent on the success of each one. My question centers around Basically if Task 3 is successful then perform task 4 if successful then reprocess task 3 and on the success of that perform task 5...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help :)