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  SQL Server Development (2000)  DTS - how can I do this?

Author  Topic  gloverr Starting Member 1 Post Posted - 2001-05-21 : 10:35:56 Hi all, I am new to the DTS game - or at least to trying to do anything other than transfer rows between databases with identical structures. I now need to create a far more complex DTS package to transfer data between an SQL Server database (I am using SQL Server 7.0) and an Oracle database. I have no trouble in making the connections and performing simple DTS's beween the two. However, my current task is more complicated. Problem 1: In one database I would store fifty values as 5 five records each containing 10 values (i.e. has ten fields). However, in the other database these fifty values would all be stored as one record (i.e. one row with 50 fields). How could I go about creating a DTS to transfer this information? Problem 2: These values should only be transfered if certain conditions are met in an another unrelated table. For example, a flag in another table indicating that transfer of the said values should occur. Any help with either of these problems would be much appraciated. Thanks in advance, Ross