Thanks 4 reply.

See i am new to this SSIS. Previously i was working on OLAP services 2000 where I truncated my dim and fact tables and then reload the dim...

I am not wasting any 1's time, just seeking help so as to solve my purpose.

Hi All,

There is a tool known as Data Replication Tool – Daffodil Replicator.

It does a replication between DB2 and SQL Server.

http://enterprise.replicator.daffodilsw.com/index.html

Firstly the database is quite big as it is an ERP database.

Secondly there are many cases where the updated data is not dependent on the last modified date, for example...

No I am specifically looking for a tool that provides log shipping between cross database platforms