Avatar of Harreni
Flag for Saudi Arabia

asked on 

Add new column with a fixed value when importing data from excel to SQL using SSIS package

Hi Experts,

I'm using SSIS package to import data from EXCEL to SQL; the EXCEL has only 3 columns however SQL has 4 columns. I want to fill the column number 4 in SQL with a fixed value for all rows. How to do that in details?

Thanks a lot in advance.
Microsoft SQL ServerMicrosoft ExcelSSIS

Avatar of undefined
Last Comment

8/22/2022 - Mon