Hi @Nicky ,
What about the latest Microsoft® OLE DB Driver 18 for SQL Server?
It is available since 2018. Its latest version 18.5
All other OLEDB providers for SQL Server are deprecated now.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi
I am using ADO.NET Source in Data Flow task. I have to transfer more than 1 million rows, cannot use OLEDB source because of encrypted data.
I have set Default Buffer Max Rows - 40000
Default Buffer Size - 16777216
Still data transfer is very slow.
I will really appreciate any help on this.
Thanks !
Hi @Nicky ,
What about the latest Microsoft® OLE DB Driver 18 for SQL Server?
It is available since 2018. Its latest version 18.5
All other OLEDB providers for SQL Server are deprecated now.
@Yitzhak Khabinsky : Can I read encrypted data using OLEDB ?
Hi @Nicky ,
1.Could you please divide the 1 million rows into different groups?
Then use one more data flows to load data in the Data Flow Task.
2.This topic provides suggestions about how to design Integration Services packages to avoid common performance issues. This topic also provides information about features and tools that you can use to troubleshoot the performance of packages.
Please refer to Data Flow Performance Features.
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.