Working with Flat Files in SSIS – Datatypes

In my experience working with flat files in Microsoft Integration Services can be quite cumbersome sometimes. There are numerous swtiches and options that can be configured to smoothly load CSV files into your database. Configuring things the wrong way may cause your ETL process to crash in case a CSV file changes its structure or[…]