SSIS：错误信息总结

最新推荐文章于 2022-09-08 15:39:58 发布

qq_26774013

最新推荐文章于 2022-09-08 15:39:58 发布

阅读量2.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： SSIS

本文链接：https://blog.youkuaiyun.com/qq_26774013/article/details/82380994

当SSIS的Sequence Container中包含两个Data Flow并同时执行时，可能出现错误。解决方法是将每个Data Flow放入独立的Sequence Container。这样调整后，SSIS包能正常运行，避免执行出错。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、同一个Sequence Container中包含两个Data Flow的时候，单独执行其中一个Data Flow是没有问题的，但是同时执行两个Data Flow的时候，容易出现如下的错误信息

 Source=[Data Flow Name]; Error Code=-1071636471; Error Description=SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Connection is busy with results for another command".

Source=[Data Flow Name]; Error Code=-1071636406; Error Description=Unable to retrieve column information from the data source. Make sure your target table in the database is available.

Source=[Data Flow Name]; Error Code=-1073450901; Error Description="OLE DB Source" failed validation and returned validation status "VS_ISBROKEN".

Source=[Data Flow Name]; Error Code=-1073450996; Error Description=One or more component failed validation.

Source=[Data Flow Name]; Error Code=-1073594105; Error Description=There were