asked on

SSIS - How to Create Package to INSERT and/or UPDATE a table's Columns if they CHANGE?

Experts,

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.

Thanks!

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Marcus Aurelius

ASKER

thank you for your help and input this table is updated outside of this SSI S package it's constantly updated throughout the day that's table 2.

what I really need is just to insert all new records based on an account ID and then update any of the columns in the table2 that have any changed data from table one

with this in mind can you please again give me a high-level summary of which tasks or objects to pull onto the SSI S package and then how to configure them just briefly thank you

Marcus Aurelius

ASKER

just to remind you this would be a nightly update that I need.

awking00

I think you might want to look at the merge statement. Can you provide some sample data and what you're expected results should be?