Error: 0xC0202009 at 01_XXXX, Connection manager "SourceDB - AW DEV": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D.
Error: 0xC00291EC at Check AW1 Status, Execute SQL Task: Failed to acquire connection "SourceDB - AW DEV". Connection may not be configured correctly or you may not have the right permissions on this connection.
Task failed: Check AW1 Status
SSIS package "01_XXXX.dtsx" finished: Success.
单独测连接是成功了，Data Flow里组件也能预览到DB的数据，但是一运行整个dtsx就报这个错。
------解决方案--------------------
你在SSIS中的连接跟测试的一样吗？
------解决方案--------------------
An OLE DB error has occurred