Solved

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

Posted on 2010-09-16
1
2,322 Views
Last Modified: 2012-06-21
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.  
0
Comment
Question by:DDB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
DDB earned 0 total points
ID: 33705690
I resolved this problem by resetting flag RetainSameConnect  to false for MySQL Connection  component in ConnectionManages.
1

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question