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.’