How to close datareader for ADO.NET source

Question

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".

Answer 1

Hi @nikz22,

You need to set connection property RetainSameConnection value as False.

Answer 2

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.

Answer 3

@ YitzhakKhabinsky-0887

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