Home Forums Data Warehousing Integration Services SSIS package for INSERT/UPDATE from Oracle to SQL server Table RE: SSIS package for INSERT/UPDATE from Oracle to SQL server Table

  • July 28, 2014 at 1:26 am

    #1732710

    Guitar_player (7/28/2014)

    Hi ,

    I need some info. about the Insert and updating the Records from Oracle Table to SQL server table using the SSIS packages and Attunity as the Source. Let me tell you my requirement

    I have got a table in Oracle DB which has got a 'S_ID' and many Columns and 'DATEM' columns

    so now i want to insert the new records and update the Exsiting records based on the Datemodified(DATEM) column into my sql table from Oracle..

    I know that this kind of requirement are already available in net when i googled but i am unable to understand what to do and what are steps and what are the columsn to compare .

    Please suggest me the ssis package and what are the transformations and any comparison columns i need to refer ?

    Since you are indeed doing a full merge, I would suggest to use a staging table for the ORA recordset and a stored procedure with the MERGE statement.

    😎