Load the data by using Dynamic RDBMS Stage in the SQLSERVER

cnu · Post by **cnu** » Tue Aug 05, 2008 10:42 am

Hi:

I am using the Dynamic RDBMS Stage to load the data in SQL SERVER database in the target side.

My requirement is inserting the new records only.
For example im getting the 12 records from source, but 10 records already therein the target table,i have to insert only 2 records means ignore the existing records,no need updation also for existing records.

Please advice me which property can i choose from the updateaction combo in the Dynamic RDBMS Stage .

Thanks in advance
cnu

ray.wurlod · Post by **ray.wurlod** » Tue Aug 05, 2008 4:24 pm

No, this rule says to generate INSERT statements only. It will attempt to process all the rows that you send to the stage.

YOU have to organize that only the new rows reach the stage.

cnu · Post by **cnu** » Tue Aug 05, 2008 6:05 pm

Ray !!

Thank you so much,Can i select " INSERT NEW ROWS ONLY" from the update property Combo ,I think this will insert new rows only.

Thanks
cnu

ray.wurlod · Post by **ray.wurlod** » Tue Aug 05, 2008 8:53 pm

If you don't mind all the errors that are generated when you send rows that already exist in the table, yes.

Make sure that you don't send these rows.