I require a easy and best solution for the following situation
Actually i have identical 6 operational databases running at 6 different locations. All database structures remain same. I have designed a DataWarehouse database and created a OLAP cube. Periodically i wanted to pupm data from all 6 operational databases to my datawarehouse database using DTS.
Before pumping i need to verify that the data to be copied does not exist already in the DataWarehouse table.
Please suggest me a good idea to proceed.
Thanks in advance
Ram