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 : 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.