I think you should explain your setup a little bit more if you want an answer that you can use.

If I understand you correct, then you have two databases A and B and in them there are some tables Tbl1, Tbl2, Tbl3. They should be syncronized?

SUGGESTION 1:

You could use replication instead of SSIS, and depending on a lot of factors you should choose between Snapshot, Transactional or merge replication.

SUGGESTION 2:

If you want to you SSIS, then a very easy way is to add two task to your controlflow:

1) A SQL Task

2) A data flow task

Before you do that, then you should add a connection to Database A and Database B.

The SQL Task could empty all rows in the destination table.

The dataflow task you add a source --> Choose the table in the source --> add a destination and drag the line between source and destination.. Do some minor setup in the destination and it is running.

SUGGESTION 3:

Also use SSIS, but only have a data flow task, where you have a source and then you choose the transformation Slowly changing dimensions and configure that.

BUT BUT BUT!! THere are many other ways to do it, and it really depends on what you want to achieve.

Soren