-3

we have oledbCommand Transformation for Update,delete pupose in SSIS it works fine but it will reduce the performance when we have huge amount of data so we can write a query in execute sql task in control flow pane in ssis for insert,update record i know this works but i don't know how to do so guys please help me.

sandhiya
  • 133
  • 2
  • 3
  • 17
  • 1
    Please be more specific - your current question is too broad. You may omit 'give me a proper answer'. – rudolf_franek Sep 20 '16 at 07:00
  • 2
    Usually we use oledbCommand transformation for update table but same thing we can do from the query in execute sql task in control flow pane in SSIS – sandhiya Sep 20 '16 at 07:01

1 Answers1

1
You can achieve this in two ways using execute sql task.
1.Insert data into global temporary table,then use execute sql task update your target table with join temporary table and can also insert data to your target table using temporary table.
2. Insert data into in dummy table(database) then update and insert target table using this dummy table. You can use merge statement for insert and update.
user2173966
  • 136
  • 3
  • Awesome right answer thank you some guys without knowing question they just simply give minus marks rudolf_franek – sandhiya Sep 24 '16 at 06:25