Typcial Fastest Connection Manager to use through Drivers/Attunity wrapper for Data Export
Category: sql server ssis
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
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