sql server 2000 dts 包在计划时失败
我有一个 SQL Server 2000 dts 包，它将数据从 DBF 文件复制到 SQL 表 我已经创建了系统 DSN 并为连接和数据库文件本身提供了 UNC 名称。 手动运行时运行顺利，但作为作业安排时失败？ 我用Google搜索发现这与SQL Server代理等的权限有关 谁能指导我找到正确的来源/发布解决方案？ 作业历史记录中“错误表明 xyz.dbf 不存在”
这是相关但单独的问题 如果我使用 dts 包将数据从一个 SQL 服务器提取到另一个 SQL 服务器仅提供了一个条件，例如，如果 SourceServer 表的值为“OK”，则在服务器之间复制数据 即如果 SourceServer.SourceDB.Dbo.CheckStatusTable.Statuscolumn="OK" 则复制该值，否则不复制 如果我有类似上述的情况，我该如何将其嵌入到 dts 包中？ 谢谢
I have a SQL Server 2000 dts package which copies data from a DBF file to SQL Table
I have created a System DSN and provided UNC Names for both Connection and Database file itself.
It runs smoothly when ran manually but fails when scheduled as a job?
I googled and found that it has to do with the permissions of SQL Server Agent etc
Can anyone guide me to the right source/post a solution?
"The error says xyz.dbf doesn't exist" in the job history
This is related but separate question
If i am pulling data from one SQL server to another using dts package provided a condition only,For example ,copy the data between the servers if SourceServer table has a value "OK"
i.e if SourceServer.SourceDB.Dbo.CheckStatusTable.Statuscolumn="OK" then copy the value else do not copy
If I have something like above condition how do i embed this into a dts package?
Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
嘿 - 我将回答您帖子中有关您收到的错误的第一个问题。当您手动运行 DTS 包时，它会使用您的权限在您的上下文中运行。当作为计划作业运行时，包在作业代理（在本例中为 SQL Server 代理）的上下文中运行。
代理似乎缺乏您尝试完成该操作所拥有的权限。由于错误提到了 DBF 文件，因此我将从这里开始。检查文件本身的任何权限或上下文是否正确传递。
Hey - I'll answer the first question in your post regarding the error you are receiving. When you run a DTS package manually, it runs under your context using your permissions. When run as a scheduled job, the package runs under the context of the job agent, in this case SQL Server agent.
It appears that the agent is lacking permissions that you have in attempting to complete the operation. Since the error is mentioning the DBF file, I'd start there. Check any permissions for the file itself or whether the context is being passed properly.