Typcial Fastest Connection Manager to use through Drivers/Attunity wrapper for Data Export

Visakh16 on Fri, 13 Jul 2018 14:24:58

See

http://henkvandervalk.com/speeding-up-ssis-bulk-inserts-into-sql-server

http://henkvandervalk.com/how-to-load-data-fast-into-sql-server-2016

JP_Quinn on Fri, 13 Jul 2018 16:53:00

I'm more interested in doing something like change within the connection manager OLEDB to ADO.NET or tweaks within than to rebuild a whole new elaborate flat file process. Which of these are faster or can be tweaked for performance improvement? Thanks

Dan Guzman on Sat, 14 Jul 2018 01:25:45

SSIS is native code (unmanged) so it would be best to use OLE DB to avoid inter interop performance penalty with .NET (managed).

Pirlo Zhang on Mon, 16 Jul 2018 07:09:24

Hi JP_Quinn,

Difference between ADO NET source and OLE DB Source

Regards,

Pirlo Zhang 

Visakh16 on Mon, 16 Jul 2018 07:25:14

I'm more interested in doing something like change within the connection manager OLEDB to ADO.NET or tweaks within than to rebuild a whole new elaborate flat file process. Which of these are faster or can be tweaked for performance improvement? Thanks

This has some performance comparison of OLEDB vs ADO.Net

http://www.fourmoo.com/2013/06/19/ssis-fastest-data-flow-task-item-for-transferring-data-over-the-network/