#abuzafor on behalf of Abu Zafor Khairuzzaman
It is a common scenario, when we need a script, package or something else to perform insert and update in a table simultaneously. Sometimes the task seems easy and sometimes it takes so much time to perfectly synchronize the databases. In this blog post we will try to create a SSIS package that performs the synchronization task by performing upsert (Insert/Update) using SSIS lookup transformation. | Tips & Tricks: SSIS: Perform upsert (Update/Insert) using SSIS Package | Tips & Tricks: SSIS: Perform upsert (Update/Insert) using SSIS Package |

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.