Hi, Please tell me how can I imp

[sandhu]

Hi,

Please tell me how can I implement 'Update as Insert' in Update Strategy transformation?
I have implemented 'Update as Update' and 'Update else Insert' using the look-up transformation.
But, for 'Update as Insert', if I tick the boxes 'Insert' and 'Update as Insert' in the Edit Tasks->Targets->Properties, then all the rows from the Source are inserted in to the Target.
But if I uncheck the 'Insert', then following error is given --
'ERROR: Target table <table-name> does not allow INSERT'
in the session log.
Please suggest a solution.

Thanks in advance