SSIS：错误信息总结

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 errors during task validation.

,
   at BL.TaskProcessService.OperationProvider.RunSSIS(ITaskAction action)

修改之前的SSIS如图所示

初始设计

为了保证SSIS可以顺利执行，可以将两个Data Flow分别放在两个Sequence Container中，如图所示

修改设计

如此在页面上调用运行SSIS就不会出错了

 

版权声明：本文为qq_26774013原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。