October 30, 2003 at 9:02 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 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
November 3, 2003 at 8:00 am
This was removed by the editor as SPAM
November 5, 2003 at 8:08 am
When you get timeout errors specially after moving from one domain to another the usual problem is CONECTIVITY.
Check that the Account running the package can connect to the previous datasource!
If you are in a different domain I would use SQL Authentication and a dynamic property task to handle the configuration of it!
You could also establish trusts between the domains to use integrated security but that's your network admins guys call and I don't know if that is feasible in your case.
HTH
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply