Please tell me if I can create SSIS package for the below requirement:
I have source data in 2 excel files. Data from both these excel files should be loaded to the same single Fact table. The column names in excel files and table are not same. I have a Reference table which has the column mappings between excel and Fact Table.
I have to refer this Reference Tabel for column mappings, plus i have to add some derived columns (Created_Date) to load the Fact_Table.
I have given a sample data structure below:
OrderNumber OrderQuantity OrderDate
Order10001 100 01-01-2011
CustomerNumber CustomerName CustomerAddress
Customer0001 CCPrivateLtd India
View Complete Post