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 ?