Category Archives: SSIS

SSIS: Use Two OLE DB Destination Adapters to Catch Insertion/Constraint Errors

If you are using SQL Server Integration Server (SSIS) packages to insert large volumes of data, you have¬†undoubtedly¬†encountered incorrectly formatted or typed data in your data source including precision errors, conversion errors, and primary key/foreign key constraint errors etc. To … Continue reading

Posted in MS SQL Server, SSIS | 5 Comments