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)
 DTS Error look up

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-10 : 09:26:16
Ranjit writes "Hi,

I was trying to look up your page for an answer to a DTS error I get but I couldn't find any DTS
related articles. However if you can help me with the following it will be greatly appreciated.
I get the following error message from a DTS job I run daily.

DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_5
DTSRun OnError: DTSStep_DTSTransferObjectsTask_5,
Error = -2147221504 (80040000)
Error string:
Error source:.
The step failed.

My problem is I cannot fugure out neither which the step fails in my job
nor the description of the error number anywhere in the WEB. Any idea
how to find these out please?


Thanks."
   

- Advertisement -