I am a novice in SSIS and would like to achieve the following.
I will be given an Excel file as a data source which will have data. I will need to use SSIS packages to
extract this data from Excel into SQL tables.
I think I will be using SQL Server 2008 for Development.
I would like some useful links and articles on how to manipulate data from Excel using SSIS packages.
One particular problem I would be concerned about is that the tables being inserted into may already
contain the same data, so in cases where the same data already exists the package should update
Also any articles where I can get information on Joining in SSIS packages will be really helpful.
If I can get a sample project that would be ideal.