[This is just for sharing information for those common asked questions collected from forums. If you have any better way or feedback, please directly reply in this thread so that community users can benefit from your answers.]
Question:
When I execute my SSIS package, it failed with the error message:
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 Native Client" HResult: 0x80004005 Description: "Connection is busy with results
for another command".
Answer:
The error message usually indicates that there are multiple parallel running SSIS tasks sharing a same connection and that you set your connection manager’s
RetainSameConnection property to True. If one task has not finished, but the others are sending requests on the same connection, this issue may occur.
To resolve this issue, you can simply change the property value to False. If you want some tasks to share a same connection, it is recommended that you have these tasks executed in sequence. For parallel tasks with the same data source, it is recommended
that you set it to False or create separate connection managers for them.
Please remember to mark the replies as answers if they help and unmark them if they provide no help
