SSIS There is already an open DataReader associated with this Connection which must be closed first.

I try to create SSIS Package in SQl server 2008. I added about 50 data Flow Tasks, each task has connection to MYSQL table, data conversion component and SQl server table as destination. when I tried to execute the package the second Data Flow task  failed with error:

Error: 0xC020838F at tableName, ADO NET Source [1]: An error occurred executing the provided SQL command: "select * from "dbname"."tableName"". There is already an open DataReader associated with this Connection which must be closed first.

Should I add component in each DataFlow task to close a DataReader and how it could be done if it's a cause of this problem?


Appreciate your help.  
LVL 3
DDBAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
DDBConnect With a Mentor Author Commented:
I resolved this problem by resetting flag RetainSameConnect  to false for MySQL Connection  component in ConnectionManages.
1
All Courses

From novice to tech pro — start learning today.