ssis

Fix ssis 2008 Error - The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."
When importing a datasource from a flat file today (a csv), (which ran through a Derived Column Transformation and then a Data Conversion Transformation before hitting SQL), I hit the following error in SQL Server Integration Services 2008 (ssis 2008): "Data conversion failed while converting column .....The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data." The dataviewers and error output ssis debugging techniques didn't