Hi,
I have a excel file which contains around 10 MB data and need to dump this data into a SQL server table.I would like to know what is the better way of doing this..
I am planning to do this in SSIS (quite new) and I need some light on it on how to proceed.
1)Excel has more no of columns than database table and I need to add them in destination table while doing the export.--I am planning to use derived column transformation(there are like 8 columns that need to be added).
2)Use a lookup transforamtion to update the matching rows based on the unique ID in both source and destination.
3)As of now needs to dump the historical data,bit later on-wards it should be updated with the live data,so need to schedule the package.
Please let me know if this is the right order to follow and also let me know the better way to do this...
Thanks...