Solved

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

Posted on 2010-09-16
1
2,214 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
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: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone 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

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 Copy Database Wizard 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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

837 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