MS SQL Server DTS - Rows keeps on adding, even after I end DTS process.

Author

Rows keeps on adding, even after I end DTS process.

k_s

2005-09-22, 11:24 am

Today I faced a weired problem.
I have a DTS package which is scheduled daily, generally it takes around 15
minutes to get fresh data. Due to some problem we had to clear the tables and
start all over again. I have done it previously and the DTS took around 4.5
hrs to complete for around 58000 rows (it has a cursor and complex
calculations on each row).
This time the total row count was 69000 and I ran the DTS manually. It took
around 8 hrs, and still didn't end. I killed the process using task manager >
end task.
When I return back to querry analyzer to clear the table I noticed that even
after I clear the table, some rows were still there.

I kept on trying Select count(*) , and noticed that it was increasing with
every run.
Finally, I changed the table name and rename it back after some time. This
time the row addition stopped.

ne guess y it happened, and does it have ne relation with that DTS going on
for so long?

thanks

Allan Mitchell

2005-09-22, 8:24 pm

Did you check to see that the process doing the inserts was dead? When
you stop a package SQL Server does not stop what it is doing
immediately, DTS will wait until it has finished the current piece of
work.

Allan

"k_s" <ks@discussions.microsoft.com> wrote in message
news:B91BBFD5-D34D-4358-ADB8- E21E98F0EED9@microso
ft.com:

> Today I faced a weired problem.
> I have a DTS package which is scheduled daily, generally it takes around
> 15
> minutes to get fresh data. Due to some problem we had to clear the
> tables and
> start all over again. I have done it previously and the DTS took around
> 4.5
> hrs to complete for around 58000 rows (it has a cursor and complex
> calculations on each row).
> This time the total row count was 69000 and I ran the DTS manually. It
> took
> around 8 hrs, and still didn't end. I killed the process using task
> manager >
> end task.
> When I return back to querry analyzer to clear the table I noticed that
> even
> after I clear the table, some rows were still there.
>
> I kept on trying Select count(*) , and noticed that it was increasing
> with
> every run.
> Finally, I changed the table name and rename it back after some time.
> This
> time the row addition stopped.
>
> ne guess y it happened, and does it have ne relation with that DTS going
> on
> for so long?
>
> thanks

k_s

2005-09-26, 7:23 am

HI Allan,
Yes it was running.
Silly problem.
thanks neways.

"Allan Mitchell" wrote:

> Did you check to see that the process doing the inserts was dead? When
> you stop a package SQL Server does not stop what it is doing
> immediately, DTS will wait until it has finished the current piece of
> work.
>
>
>
> Allan
>
>
>
> "k_s" <ks@discussions.microsoft.com> wrote in message
> news:B91BBFD5-D34D-4358-ADB8- E21E98F0EED9@microso
ft.com:
>
>
>

Sponsored Links