Ole Error 80074005
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » General » DTS Scheduled Job Failure DTS Scheduled Job Failure Rate Topic Display Mode Topic Options Author Message ecreeseecreese Posted Thursday, October 30, 2003 8:49 AM Grasshopper Group: General Forum Members Last Login: Monday, December 14, 2009 11:41 AM Points: 19, Visits: 35 Problem I have some scheduled DTS package jobs that ran fine before but are now failing. I recently Upgraded the server for our membership database and it now resides on another domain. This server that has the DTS failures pulls from the membership database. Not sure if the domain switch is causing this. Below is the Enterprise Manager Error output. Below that is the error log I set in the package up to write to. I inherited this setup. Database is SQL 7 running SP4.DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun OnError: D... Process Exit Code 2. The step failed. **********************************************The execution of the following DTS Package succeeded: Package Name: tblMemberLoginImportPackage Description: (null)Package
this : DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package http://www.sqlservercentral.com/Forums/Topic17756-9-1.aspx execution complete. Process Exit Code 1. The step failed. Where can I find sqldts.hlp ? Best regards, JOBI Top DTS Error: -2147008507 (80074005); by Euan Garde » Tue, 27 Feb 2001 17:09:25 The problem here is that whatever you were doing in your execsql task against sql server the connection timed out. -Euan Quote:> Where do I find error-descriptions/solving hints for DTS-jobs that give an > error like this : > DTSRun: Loading... DTSRun: Executing... http://www.verycomputer.com/156_729cc8d31af3dc52_1.htm DTSRun OnStart: > DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Quote:> Error = -2147008507 (80074005) Error string: Unspecified error > Error source: Microsoft Data Transformation Services (DTS) Package > Help file: sqldts.hlp Help context: 1100 Error Detail Records: > Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: > Unspecified error Error source: Microsoft Data Transformation > Services (DTS) Package Help file: sqldts.hlp Help context: 1100 > Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: > Timeout expired Error source: Microsoft OLE DB Provider for SQL Server > Help file: Help context: 0 DTSRun OnFinish: > DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process > Exit Code 1. The step failed. > Where can I find sqldts.hlp ? > Best regards, > JOBI Top DTS Error: -2147008507 (80074005); by jobi » Fri, 02 Mar 2001 17:55:27 Thanks for the response. Where can I find this kind of information/explanation ? Jobi > The problem here is that whatever you were doing in your execsql task > against sql server the connection timed out. > -Euan > > Where do I find error-descriptions/solving hints for DTS-jobs that give an > > error like this : > > DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: > > DTSStep_DTSEx
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 DTS Package fails in SQL http://forums.databasejournal.com/showthread.php?18447-DTS-Package-fails-in-SQL-Agent-scheduled-job Agent scheduled job If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can http://www.devsuperpage.com/search/Articles.aspx?G=9&ArtID=182767 post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 ole error of 4 Thread: DTS Package fails in SQL Agent scheduled job Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-20-2000,10:41 AM #1 Gaeton Cavarocchi Guest DTS Package fails in SQL Agent scheduled job I have created a package in SS 7.0 that ole error 80074005 connects to a SS 6.5 database and performs an update on a table. Very simple not complicated. When I execute the package it's successful. When I schedule it to run it fails with the following error: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 1331 (533) Error string: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()). Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error: -2147467259 (80004005); Provider Error: 1331 (533) Error string: [Microsoft][ODBC SQL Server Driver]Client unable t. The step failed. I have tried connecting using ODBC DSN and OLE DB with same results. Any help would be appreciated. Thank you, Gaeton Reply With Quote 12-20-2000,11:51 AM #