Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 24th, 2009, 12:34 AM
Registered User
 
Join Date: Feb 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.
 
Old February 25th, 2009, 04:53 AM
Friend of Wrox
 
Join Date: May 2006
Location: Helsingborg, , Sweden.
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Error code 80004005 generally means you have not permission to access the object.
How do your connection string look like?
Do you have the correct password for your username?




Similar Threads
Thread Thread Starter Forum Replies Last Post
description != '' equivalent XMLUser XSLT 3 March 1st, 2008 12:58 PM
to get description of table MunishBhatia SQL Server 2000 2 December 5th, 2006 01:26 PM
Error description from DDQ OnInsertFailure asharma SQL Server DTS 0 June 23rd, 2004 11:25 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.