I am creating a SSIS Package for importing excel file(with Several tables in the form of named ranges) from sharepoint to sql server(database) tables.
I tried importing file to a local folder using script task and then storing it as a excel source and exporting the data to oledb destination.
The Problem is that the destination tables have foreign key constraint set. and There are few columns such as created day and updated day which use the datetime data type,and these values are not present in the excel source.
How can i perform a transformation for adding these data while fetching the data from excel source to the oledb destination.
Your suggestions can be a valuable source. Thanks in advance!