SSIS’s ‘Fast Load’, ‘INSERT BULK’ and Bcp

SSIS has an option called ‘Fast Load’. That means using the bcp application to move data to SQL without issuing INSERT commands, bypassing the relational DB engine. It is dramatically faster, but invalidates subsequent transaction log backups.

insert bulk [dbo].[Table Name]([columnn name] datatype) with (TABLOCK,CHECK_CONSTRAINTS)

SQL profiler shows the above syntax, which according to Books Online doesn’t exist. It is just SQL profiler’s way of showing what is essentially a binary event, not a T-SQL event.

Comments are closed.