如何将DTS包作为计划作业运行 [英] How to Run a DTS Package as a Scheduled Job
问题描述
大家好，
我试图将一个数据库从一台服务器复制到另一台服务器。
DTS包手动运行，但DTS包在计划作为作业运行时失败。
以用户身份执行：ServerName \ WindowsWindowsAuthontication。 ... DTSRun OnStart：DTSStep_DTSTransferObjectsTask_1 DTSRun OnProgress：DTSStep_DTSTransferObjectsTask_1;转移的脚本对象; PercentComplete = 0; ProgressCount = 0 DTSRun OnError：DTSStep_DTSTransferObjectsTask_1，错误= -2147024891（80070005）错误字符串：访问被拒绝。错误源：Microsoft数据转换服务（DTS）包帮助文件：sqldts80.hlp帮助上下文：1100错误详细记录：错误：-2147024891（80070005）;提供程序错误：0（0）错误字符串：访问被拒绝。错误源：Microsoft数据转换服务（DTS）包帮助文件：sqldts80.hlp帮助上下文：1100错误：-2147024891（80070005）;提供程序错误：0（0）错误字符串：访问被拒绝。错误源：Microsoft数据转换服务（DTS）包帮助文件：sqldts80.hlp帮助上下文：5700错误：-2147467259（800040。步骤失败。
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.
推荐答案
它是一个权限问题。当它作为一个作业运行时，它正在使用SQLAgent上的帐户。无论运行什么帐户，您的SQLAgent服务都需要具有适当的权限。我相信在工作中还有一个设置告诉它使用特定帐户。
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.
这篇关于如何将DTS包作为计划作业运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
