How to close datareader for ADO.NET source

Nicky 116 Reputation points
2021-03-17T17:09:32.62+00:00

Hi

I have created a package for data migration. My package use both execute SQL Task and Data flow task.
First data flow task(using ADO.NET source) works smoothly, when package flow reach second data flow task (using ADO.NET source), I get error

"There is already an open DataReader associated with this Command which must be closed first."

[SSIS.Pipeline] Error: "ADO NET Source" failed validation and returned validation status "VS_ISBROKEN".

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,509 questions
0 comments No comments
{count} votes

2 additional answers

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points
    2021-03-18T02:03:34.42+00:00

    Hi @Nicky ,

    First data flow task(using ADO.NET source) works smoothly, when package flow reach second data flow task (using ADO.NET source), I get error
    "There is already an open DataReader associated with this Command which must be closed first."

    Please create 2 ADO.NET connection managers in SSIS package.
    First data flow task(using ADO.NET source) can use ADO.NET connection manager1, and second data flow task(using ADO.NET source) can use ADO.NET connection manager2.

    Best regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Nicky 116 Reputation points
    2021-03-18T14:22:59.94+00:00

    @ YitzhakKhabinsky-0887

    Thanks! I chnaged the property to false and my solution is working perfectly fine.

    0 comments No comments