Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-09-16
1
Medium Priority
?
2,379 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach 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.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

722 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