bennyaustin.com
SSIS: ADO.NET Destination in Bulk Insert Mode and Foreign Keys
Bulk Insert option for SSIS ADO.NET Destination which is available since SQL Server 2008 R2 improves the data load speeds significantly. Using the bulk insert mode does come with a catch, especiall…