question

Susan Cranford avatar image
Susan Cranford asked

SQL2005 dtsx packags stopped working but all connections okay

This is very strange. All of a sudden packages that I have been using for months will not complete but there are no errors. The connections are all successful. It will start but then just hangs there and same trying to preview. Any ideas ??

sql-server-2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered

Aren't there some locks on some tables the dtsx are using? Take a look on the activity monitor so check whether it is not blocked by locks from other connections.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Susan Cranford avatar image
Susan Cranford answered

Thank you but that is not the problem. I am currently the only person using sqlserver. It is very odd that this just happened for the first time today and I have been running these packages weekly for over a year.

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
For user you were looking that nothing is keeping locks on the tables? Are you able to make updates to there records from eg. management studio? I'm asinking because 2 times happen to me, that an application crashed but event the app was not running the SQL client was keepking the connections alive (something with the connection pooling have to go wrong). Only reboot of the machine from which the blocking connection was established helped. (I was even not able to kill the connection on the SQL server).
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered

something out of the blue like this could be a password change somewhere??

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Susan Cranford avatar image
Susan Cranford answered

Unfortunately that is not it either. I can successfully hit the tables outside of the dtsx package. Thanks for your help !! No errors come up anywhere it just appears to keep running but on the data tab no records are being processed.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.