sql serverssisssis-2012
I need an SSIS package that loops back to the initial execute task after the wait for delay block is executed. here is the logic for the below package: execute SQL task executes a set of commands and after that if a condition is met, the second process(preparation sql task 1 and so on) will be executed. if the condition is not met, it will wait for some time and re-run the first task(execute sql task). I am stuck here and cannot go any further. please help
And so to force the same session to be used, in your connection manager, under the Properties settings, you can set the RetainSameConnection to True to force a single connection for your package versus using a pool.
I could not resolve this issue and changed my approach to utilize a SQL Job instead of running the package directly from a powershell script.
Summary of solution:
To run a SQL Job with a custom you must also create:
I still wonder what's different about this approach versus the 'interactive' approach listed above. Both approaches run with the exact same identity and privileges!
For an in-depth description of the steps required to configure a SQL Job, look at this example code for Automated Deployment of a SQL Job and Job Step.
Hope this helps someone else in the same situation -
Best Answer
You can create a For Loop Container. For an example, see the mssqltips article Configure the SQL Server Integration Services For Loop Container.