When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL. Many of the data flow tasks include the option to redirect errors down ...

Destination tables in SQL Server arrive with the datatype NVARCHAR (3000) always. This is hardcoded in the script-task "Extraction Server-SqlServer" and comes from the premise that it will be ...