Solved

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

Posted on 2010-09-16
1
2,275 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 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