SQL Server 2000 DTS 包失败并显示“失败行数超出指定的最大值”
我继承了一个SQL Server 2000 DTS包，可以将数据从SQL Server迁移到Oracle。该包每天晚上将大约 20 个表的数据移动到 Oracle，无需任何转换，然后由一组 SP 进行转换并由 GIS 应用程序使用。
本周，在 SQL Server 和 Oracle 之间的迁移过程中，包两次失败，并显示“失败行数超过指定的最大值”。不过，它每次都在不同的表上失败。
每次失败时，我们都会在第二天早上重新运行该过程，并且效果良好。因为该过程在第二次运行时有效，所以我认为在最初的失败和我们成功的第二次运行之间，数据正在被某人或某物更改。
我想更改 DTS 包以将失败的行记录在文本文档中，以便我们稍后可以对它们进行比较。
有人可以帮我吗？我似乎无法弄清楚那部分。
斯科特
I have inherited a SQL Server 2000 DTS package that migrates data from SQL Server to Oracle. This package moves about 20 tables' data to Oracle every night with no transformations, and it is then transformed by a set of SPs and used by a GIS application.
Twice this week, during the migration between SQL Server and Oracle, the package has failed with "The number of failing rows exceeds the maximum specified". It has failed on a different table each time, though.
Each time it's failed, we've rerun the process the next morning and it has worked. Because the process works the second time it's run, it makes me think the data is being changed by someone or something between the initial failure and our successful second run.
I would like to change the DTS package to log the failing rows in a text document so we can compare them later.
Can someone help me with that? I can't seem to figure that part out.
Scott
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
没关系。我在“选项”选项卡下找到了“异常文件”。
Never mind. I found the Exceptions File under the Options tab.