September 17, 2010 at 5:39 am
My package uses checkpoints and goes like this:
Run TSQL (These steps may be TSQL or procedure)
For Each Container 1
Run TSQL
Load Data
End container 1
Run TSQL
For Each Container 2
Run TSQL
Copy Data from one table to another
End Container 2
For Each Container 3
Run TSQL
Copy data from on table to several others.
End Container 3
Run TSQL
Run TSQL
Run TSQL
The containers are to group the steps together. In this case I need to clear the respective tables of the records this package might load, in case it is restarted.
So each container contains the clear-the-table(s) step then the load data step.
The problem is when running the package, and the For Each container 3 completes successfully before the package stops, when it is restarted it does not pick up at the TSQL after the container, it runs For Each container 3 again.
When I stop it at other points in the package the restart picks up as expected, within the container that was executing when the stop occurred.
Anyone have any ideas on why this might be?
I can post the XML of the package if that will be beneficial.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 17, 2010 at 6:06 am
Stamey (9/17/2010)
My package uses checkpoints and goes like this:Run TSQL (These steps may be TSQL or procedure)
For Each Container 1
Run TSQL
Load Data
End container 1
Run TSQL
For Each Container 2
Run TSQL
Copy Data from one table to another
End Container 2
For Each Container 3
Run TSQL
Copy data from on table to several others.
End Container 3
Run TSQL
Run TSQL
Run TSQL
The containers are to group the steps together. In this case I need to clear the respective tables of the records this package might load, in case it is restarted.
So each container contains the clear-the-table(s) step then the load data step.
The problem is when running the package, and the For Each container 3 completes successfully before the package stops, when it is restarted it does not pick up at the TSQL after the container, it runs For Each container 3 again.
When I stop it at other points in the package the restart picks up as expected, within the container that was executing when the stop occurred.
Anyone have any ideas on why this might be?
I can post the XML of the package if that will be beneficial.
Thanks,
Chris
Are you running any transactions?
Raunak J
September 17, 2010 at 7:02 am
No, no explicit transactions.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
September 22, 2010 at 5:23 am
I will play with some of the options, but I have already read this page a few times.
Thanks,
Chris
Learning something new on every visit to SSC. Hoping to pass it on to someone else.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply