Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi All,

I have trying to copy one databse from one server to another server.

DTS package run manually, but the DTS package fails when it is scheduled to run as a job.


Executed as user: ServerName\WindowsAuthontication. ... DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0 DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147024891 (80070005) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 5700 Error: -2147467259 (800040. The step failed.
Posted

1 solution

It is a permissions issue. When it runs as a job it is using the account on the SQLAgent. Whatever account is running your SQLAgent service will need to have proper permissions. I believe there is also a setting in the job to tell it to use a specific account.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900