October 30, 2003 at 8:49 am
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: tblMemberLoginImport
Package Description: (null)
Package ID: {0094D69A-0493-414C-BCFB-FFCEC2B0B50B}
Package Version: {F9579C07-0684-4C4D-A91C-9BE5C1DE691E}
Package Execution Lineage: {D16FF64B-EEAC-4DAA-B13E-C08A919C9D44}
Executed On: [SERVER NAME]
Executed By: sadmin
Execution Started: 10/30/2003 5:10:04 AM
Execution Completed: 10/30/2003 5:10:23 AM
Package Steps execution information:
Step 'DTSStep_DTSDataPumpTask_1' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
(Microsoft OLE DB Provider for SQL Server (80004005): Timeout expired)
Step Error code: 80074005
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100
Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step 'DTSStep_DTSExecuteSQLTask_2' was not executed
Step 'DTSStep_DTSDataPumpTask_2' was not executed
Step 'DTSStep_DTSDataPumpTask_3' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Data Source Object name or SQL Statement is required to obtain a Rowset. (Microsoft OLE DB Provider for SQL Server (80070057): The parameter is incorrect.)
Step Error code: 8004040A
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100
Step 'DTSStep_DTSExecuteSQLTask_3' was not executed
Step 'DTSStep_DTSDataPumpTask_4' was not executed
Step 'DTSStep_DTSExecuteSQLTask_4' was not executed
Step 'DTSStep_DTSDataPumpTask_5' was not executed
********************************************
Thanks
Eric
October 30, 2003 at 9:30 am
Nothing in the logs particularly sparks anything for me.
I'd check the permissions on the account used to run the package with respect to the new domain and your package datasources.
Can you run the package manually? Or will it not run at all?
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
November 3, 2003 at 9:47 am
Eric, have you seen this article?
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269074
Elena.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply