I have created an SSIS project that will take a CSV file, upload it into a SQL Table, then it performs a query on that table with a few other tables and saves the result as a CSV and then emails the CSV file. The problem that I am having is all of the decimal fields in the query are being saved with the scale up to 10 in length. The query that I am using is actually performing calculations and rounding to 2 decimal places using the round function, but when it gets exported to the Flat File destination the rounding is no longer used. I also have set the properties in the Flat File connection to have a scale of only 2, but that didn't work either. Any suggestions?