I was doing a data conversion that involved importing data from a flat-file source into SQL Server. I fired up SSIS and created the Data Flow tasks that would move the data into the SQL Server tables. The problem was, the longer fields (i.e. a “Notes” column) were all being truncated no matter what data type I made the destination field. So I created a Data Conversion task to sit between the Flat-File data source and the SQL Server Destination. After I had tried every conceivable destination data...