Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  SQL server view replication to AS400 db2 table?

Author  Topic  drew Starting Member 1 Post Posted - 2005-01-13 : 07:34:36 hi, i'm a dts newbie need pointing in the right direction... Background: i have a case where i cannot access data held in an sqlserver database from a SAP system running on AS400 db2... i need to push the corresponding data from the sql server (and any updates, inserts and deletions) to a db2 file... i've created DTS packages in sql to perform the initial create/copy data (one off) into the AS400 - this works... Question: i need to understand the best way of making sure the data in the AS400 table corresponds directly with the data in the sqlserver view at any point in time - any updates are valid for both systems... i have to use a view as the sql database is a 3rd party system where only the views on data can be guaranteed not to change... creating triggers on tables is not an option! if anyone can give me any hints, it would be greatly appreciated. thanks in advance, drew