Question

JP_Quinn on Fri, 13 Jul 2018 14:10:33


Is it OLEDB, ADO.NET or some other method of moving a flat file and bulk load?

Replies

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/