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.