We have a college project in which we need to use SSIS (as an ETL), SSMS, SQL Server, and Power BI. We have successfully loaded our dimension tables, but we encountered a problem with the fact tables. By default, in the flat file connection manager, the data type is set to ‘string.’

To address this, we changed some fields (containing numbers) to ‘decimal’ in the flat file connection manager. In the OLE DB destination, we created a table with corresponding ‘decimal’ fields. However, when my friends tried to run the project on their laptops, it caused an error. Surprisingly, on my laptop, the conversion didn’t cause any problems. However ,after loading the tables, I checked in SSMS and noticed that values like ‘41.32’ became ‘41.00,’ and ‘0.01’ became ‘0.00.’ I’m concerned that our Power BI dashboard won’t be accurate if we don’t resolve this issue. Does anyone know of any solutions?