Post reply

DTS Table Data from Oracle to SQL Server.

  • October 18, 2005 at 1:56 pm

    #76439

    Is there a way to use DTS to transfer data from an Oracle table to SQL Server table getting only the Oracle table records that have a date that is greater that the SQL Servers table's max(date)? Kind of like:

    INSERT INTO SQL.TABLE1 FROM SELECT * FROM ORACLE.TABLE1

    WHERE ORACLE.TABLE1.CREATEDT > (SELECT MAX(CREATEDT)

    FROM SQL.TABLE1)

  • October 18, 2005 at 2:07 pm

    #598058

    It would be easier to create a sql task that populates a variable with the value of the Max(CreateDT) from sqlTable1, then pull data from Oracle.Table1 where CreatDt > ? (Global Parameter)

     

    Edit:

    http://www.sqldts.com/default.aspx?205

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply