DTS 包版本导致 SQL Server 2000 作业失败？
此时我一直遇到一个反复出现的问题，但我却没有意识到。 我在 SQL Server 2k 中设置了一个作业，其中有几个命令步骤，后面是仅调用同一服务器上的 DTS 包的 4 个步骤。 当涉及到调用包时，作业失败并且没有给出真正的原因。 好吧……
好吧，我不明白的是，如果我单独按顺序运行这些包，它们就能 100% 地工作。 我已完全删除这些包并重新添加它们并修改相应的步骤。 我错过了什么吗？
当包独立运行时，DTS 包版本控制继承的某些内容是否会导致作业失败？
谢谢。
I've been having a reoccurring problem that escapes me at this point. I have a job set up in SQL Server 2k that has a few command steps which are followed up by 4 steps that just call DTS packages on the same server. When it comes to calling the packages, the job fails with no real reason given. Ok fine...
Well the thing that I can't figure out is that if I run the packages in order separately they work 100% of the time. I've deleted the packages entirely and re-added them as well as modifying the corresponding step. Am I missing something?
Is there something inherit with the DTS package versioning that causes the job to fail when the package runs just fine as a standalone?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我们的 SQL Server 2000 数据库上的 DTS 包总是存在问题。 您可以尝试检查 Windows 事件查看器/系统错误日志，看看其中是否有更详细的信息。
在该作业失败之前，我们已经遇到了凭据问题，因为运行该作业的 Windows 帐户可能已变为非活动状态 - 因此，第一个作业运行时使用的凭据可能无权运行 dts 包，但您（作为管理员）做 ？
We've always had issues with DTS packages on our SQL Server 2000 databases. You could try checking the windows event viewer/system error logs to see if there is anything more detailed in there.
We've had credentialing issues before that jobs would fail because the windows account running the job may have become inactive - so maybe the credentials the first job is running under doesn't have access to run dts packages, but you (as an administrator) do ?