DTS Job error

  • 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

  • This was removed by the editor as SPAM

  • 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