SSIS Data Conversion06-05-2019 0 Comment(s)
Drag and drop the data flow task from the toolbox to control flow and rename it as SSIS Data Conversion Transformation.
Drag and drop EXCEL Source, Data Conversion Transformation from toolbox to data flow region.
Double click on Excel source in the data flow region will open the connection manager settings and provides option to select the table holding the source data.
he above screenshot you can observe that we are selecting the DimProducts.xls file present in our local hard drive
From the above screenshot you can observe that, we are selecting the Product Destination table present in the DimProducts.xls.
Click on columns tab to verify the columns. In this tab we can uncheck the unwanted columns also.
No Comments to Show