Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Long run after completion

Author  Topic 

Anacrusis
Starting Member

4 Posts

Posted - 2005-03-30 : 08:51:19
Hi all,

I have a DTS package for proccessing OLAP cubes on another server. This package has been running with no problems until a few days ago.

The package is run everynight via SQL Server Agent, the package executes and runs just fine, but the job will then hang for 10-12 hours longer not doing anything before it finaly finishes. I can reproduce this by executing the package manually as well.
I'm logging to a text file, but all I get is a 60MB file with which contains 1 line of astericks, and then nothing but blank spaces.

I have a ticket open with Microsoft, but they're just as stumped as I am. I'm hoping somebody here may have experienced this or may have some suggestions.

Thanks.
   

- Advertisement -