How To Insert Update delete changes from source table to Destination Table using Lookup in SSIS

[@MohammedShaik-ws1uv]

Excellent Harsha hats off to your effort Bravo and salute to your contribution for sharing the knowledge.

[@MSSQLDBATechSupport]

Thanks😊

[@manojmjmittu2735]

why parameters are not showing up in the Available destination section in OLEDB Command

[@MSSQLDBATechSupport]

This is very old video and unable to recall

[@venkataswamy.gswamy5389]

Lookup no match input can consider as new records and can insert into table correct. Why again on failure u redirected as new records. Any advantage using this approach?

[@MSSQLDBATechSupport]

Here i have redirected the failure records so that i can have an idea what are the records that got failure... so that i can maintain into as a separate table for record purpose

[@samuna8950]

in delete package the businessentityid you have chosen in delete statement in mapping the entityid you have joined with parameter is from source or destination?

[@MSSQLDBATechSupport]

Destination

[@aparnabadireddy3770]

Very nice explanation

[@MSSQLDBATechSupport]

Thanks and welcome