I need basic information on how to create a SSIS Package that will load data into a table on a Daily basis.
1. Source = DB1.Table1
2. Destination = DB2.Table2
3. Need to load all NEW Records, which are records NOT already in Table2, but are in Table1
3. Also need to UPDATE any changes to certain columns in Table2 for any changes to same records in Table1
In a nutshell, I need to know the basic Tasks / Transform Items to use for a "general" SSIS Package like this.
Please ask me any questions you may have, but I'm looking for basic information on how to accomplish this and what to look-out for in the development of this package.