469,071 Members | 1,957 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,071 developers. It's quick & easy.

No error Description

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.
Feb 24 '09 #1
0 1479

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by aartinawani | last post: by
2 posts views Thread by slinky | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.