December 30, 2003 at 4:14 pm
I have a dts package that does the following
1)Creates a table after deleting it if it exists
2)sucks data into that table using a transform data task
3)renames the table using the current date as part of the
file name
At times, the package locks up SQL server and shows that
it is in spin lock. To escpe, I have to kill the process
and restart sql server.
I have three other identical packages which only vary in
the name that they ultimately give the table. I use these
packages during physical inventory to track changes after
different counts. Two of these packages never lock up,
never! The other two lock with the same error.
We are running SQL 2000 standard on windows 2K server.
Thanks for any insight that you can offer.
Bob
December 30, 2003 at 9:44 pm
I have a couple thoughts.
(1) There is a 'Close Connection on Completion' Property you can set for the Transform Data Task.
(2) Why wouldn't you name the table as you want it to eventually be named on re-creation. You could do the following:
*Set a global variable gvNewTableName = TableNameYYYYMMDD (or whatever it is)
*Drop Table if exists - Using a Parameter in the Execute SQl Task mapped to gvNewTableName
*Use a Dynamic Properties Task to change the destination table of the Transform Data Task to gvNewTableName
*Run the Transform Data Task to load the data
December 31, 2003 at 11:23 am
Thanks Czar.
Close Connection on Completion is set, but it hasn't helped.
My gut is that the package is corrupt. I am going to try and rebuild it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply