SQL Server Performance Forum – Threads Archive

Error in Transferring Job

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

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.

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

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.

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

]]>