Importing data from UNISYS RDMS

• Colby Montgomery

  SSC Enthusiast

  Points: 151

  More actions

  May 11, 2005 at 1:43 pm

  #86141

  Hello all and thank you in advance,

  I am relatively new to MS SQL Server and am facing this situation:  My organization has an operational database using Unisys RDMS product.  This database needs to be archived off-site in a SQL Server database hourly.  Currently I constructed a DTS package which runs off and queries RDMS for its contents (SELECT * from...), then returns those contents to a SQL Server table which is in turn uploaded into the archive table, only inserting those records that the archive does not already contain.

  My question is this:  How can I use a WHERE clause in my origional SELECT statement to limit returned results to those not already contained in the off site SQL Server archive?  Is this possable?  Or do I need to investigate some sort of Transformation?

  Your thoughts are appreciated.

• DCPeterson

  SSCoach

  Points: 15266

  More actions

  May 16, 2005 at 3:40 pm

  #559137

  Since you are already able to connect to the other database and query it, all you should need to do is modify your source query to include the appropriate WHERE clause using the appropriate syntax for the target platform.  If you define your source as a query, DTS just passes the query through to the source system.

  /*****************

  If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

  *****************/