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)  No Error Description for DTS error

Author  Topic  andy3381 Starting Member 1 Post Posted - 2009-02-23 : 03:43:29 Hi, I am having a scheduled job running DTS packages on my production environment. My production server server is having Window 2003 Sp2 installed on it. Before rebuilding the server I was getting more details error messages in case job failed the error description is having more detailed error message. for example: Step 'DTSStep_DTSExecuteSQLTask_197' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Microsoft OLE DB Provider for SQL Server (80004005): Connection failure. Step Error code: 8004043B Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 Now I am getting error message like below: Step 'DTSStep_DTSExecuteSQLTask_17' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:The task reported failure on execution. ( (80004005): ) Step Error code: 8004043B Step Error Help File:sqldts80.hlp Step Error Help Context ID:1100 The same error message is there in Job History and DTS log.The error codes I am getting in the error messages are the generic ones which can contain several errors. I have checked everything and could not figure out any differences in the configuration before and after building the server. Please can someone help me to find the out the reason why now I am not getting the detailed error description and how to rectify this as without the actual errors it wil be difficult to investigate the reason for failure and to convince the client.