It is a common scenario, when we need a script, package or something else to perform insert and update in a table simultaneously....

This is a simple how-to-guide of how to set up a Send Mail Task in SSIS. It is widely used to send out an email to inform administrators...

Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say you create a package in SSDT...