SQL Server Performance

Error in Transferring Job

Discussion in 'SQL Server DTS-Related Questions' started by tandangp, Mar 18, 2005.

  1. tandangp New Member

    Hi everyone!

    I created simple DTS package to transfer jobs from one server to another server using "Transfer Jobs Task" on DTS Designer, but when I try to run the package got a message:
    "Task failed during execution"

    When I clicked OK on that message, then click the failure step, got a pop up message
    "Unspecified error"

    Does any one ever experience on this or have idea on what cause the problem?

    Any ideas or comment are greatly appreciated. You are all are very good & friendly in helping me in the past, and I really appreciate all of you.

    Have a good weekend!



    Paulus
  2. satya Moderator

    Check the DTS package log for any information on thsi behaviour.
    Ensure the SQLAGent service account has required permission to perform the task.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. tandangp New Member

    Satya,<br /><br />Thanks for your response, I appreciate it very much. I turned off the log and got this data:<br />Package Steps execution information:<br /><br /><br />Step 'DTSStep_OMWCustomTasks.OMWTransferMSDB_1' failed<br /><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:Unspecified error<br /><br />Step Error code: 80004005<br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp<br />Step Error Help Context ID:700<br /><br />Step Execution Started: 3/22/2005 4:20:13 PM<br />Step Execution Completed: 3/22/2005 4:20:37 PM<br />Total Step Execution Time: 24.641 seconds<br />Progress count in Step: 0<br />Task Log for this step:<br />-----Start Task Log-----<br /><br />Error = 1 (00000001), Description = Script Operator DBA <br />Error = 1 (00000001), Description = Script Operator Paulus <br />Error = 0 (00000000), Description = Script MSDB Object Daily Datarray Claim, Support, Card, & Admin Load <br />Error = 1 (00000001), Description = Script MSDB Object Daily HRMS Employee Load <br />Error = 1 (00000001), Description = Script MSDB Object Monthly DatarrayCB Load <br />Error = 1 (00000001), Description = Script MSDB Object Monthly DatarrayCF Load <br />Error = 1 (00000001), Description = Script MSDB Object Monthly DatarrayCF Transfers Load <br />Error = 1 (00000001), Description = Script MSDB Object OilMart Billing Load <br />Error = 1 (00000001), Description = Script MSDB Object OilMart Enroll Load <br />Error = 1 (00000001), Description = Script MSDB Object Reindex Datarray (CB & Supp) <br />Error = 1 (00000001), Description = Script MSDB Object Set CPU & DiskIO User Performance Alerts <br />Error = 1 (00000001), Description = Script MSDB Object Transfer Jobs & Logins to AHLDR1 <br />Error = 1 (00000001), Description = Script Operator Brad Garrett <br />Error = 1 (00000001), Description = Script MSDB Object Weekly Backup of all Databases <br />Error = 1 (00000001), Description = Script MSDB Object Weekly Defragment of User Databases <br />Error = 1 (00000001), Description = Script MSDB Object Weekly OilMart Reject Load <br />Error = 1 (00000001), Description = Transfer Operator DBA <br />Error = 1 (00000001), Description = Transfer Operator Paulus <br />Error = 1 (00000001), Description = Transfer Operator Brad Garrett <br />Error = 0 (00000000), Description = Transfer MSDB Object Daily Datarray Claim, Support, Card, & Admin Load <br />Error = 0 (00000000), Description = Transfer MSDB Object Daily HRMS Employee Load <br />Error = 0 (00000000), Description = Transfer MSDB Object Monthly DatarrayCB Load <br />Error = 0 (00000000), Description = Transfer MSDB Object Monthly DatarrayCF Load <br />Error = 0 (00000000), Description = Transfer MSDB Object Monthly DatarrayCF Transfers Load <br />Error = 0 (00000000), Description = Transfer MSDB Object OilMart Billing Load <br />Error = 0 (00000000), Description = Transfer MSDB Object OilMart Enroll Load <br />Error = 0 (00000000), Description = Transfer MSDB Object Reindex Datarray (CB & Supp) <br />Error = 0 (00000000), Description = Transfer MSDB Object Set CPU & DiskIO User Performance Alerts <br />Error = 0 (00000000), Description = Transfer MSDB Object Transfer Jobs & Logins to AHLDR1 <br />Error = 0 (00000000), Description = Transfer MSDB Object Weekly Backup of all Databases <br />Error = 0 (00000000), Description = Transfer MSDB Object Weekly Defragment of User Databases <br />Error = 0 (00000000), Description = Transfer MSDB Object Weekly OilMart Reject Load <br /><br />-----End Task Log-----<br /><br />Do you have any idea on what cause the problem? Anyone comments or ideas are very much appreciate it.<br /><br />Thanks!<br /><br />Paulus
  4. satya Moderator

    When errors are raised while working with Data Transformation Services (DTS) packages in the DTS Designer on computers with localized versions of SQL Server 2000 or where the Microsoft Windows operating system has been localized, a -2147467259 error code and a generic, localized "Unspecified error" are displayed, instead of the actual error.

    The package is saved if it is scheduled to run on a recurring basis or one time. Therefore, the SQL Server Agent on the destination server has to be started. The Transfer Database DTS package must be treated as any other DTS package including the requirements and permissions associated with scheduling and running the package. And also check the permission for the SQLAgent service account.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. adaikalamb New Member

    Hi,
    I got the same error so log into the server and ping the other server .If it is not pinking then you may get the error.
    try this good luck
    Regards,
    Adaikalam.B

Share This Page