The FastLoadMaxInsertCommitSize property of the OLE DB Destination is used to determine how many rows should be committed as a single transaction when using the FastLoad option. In SQL Server Integration Services (SSIS) 2005 the default value for this property was zero which meant “regardless of the number of rows, commit all of them under a ...

In this, my latest video nugget, I demonstrate and compare three ways that you can insert data into a SQL Server table from the SSIS DataFlow: OLE DB Destination without Fast Load OLE DB Destination with Fast Load SQL Server Destination The demo peels back the covers to see how these three methods actually ...