I have a DTS package that exports data from an Access database into a SQL Server database. Sometimes the package runs fine from my client machine through Enterprise manager and sometimes it hangs. Does this have anything to do with users accessing one of the databases? Has anyone had a similar problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS Package hangs periodically
- Thread starter Juice05
- Start date
Few things to monitor.
Start monitoring the CPU and Memory on Server.
When the DTS is executing, you access db is used my any users. If the record is locked it will be slow. Look any other SPIDs are locked or executing (especially system jobs like backup, reindexing) when the package is executing.
If the access db is located in a different network see any network drops.
Dr. Sql
goEdeveloper@yahoo.com
Good Luck.
Start monitoring the CPU and Memory on Server.
When the DTS is executing, you access db is used my any users. If the record is locked it will be slow. Look any other SPIDs are locked or executing (especially system jobs like backup, reindexing) when the package is executing.
If the access db is located in a different network see any network drops.
Dr. Sql
goEdeveloper@yahoo.com
Good Luck.
- Status
Similar threads
- Locked
- Question
- Locked
- Question