Here's a quick trick to keep things running. By Eric Johnson 04/12/2010 When building an SSIS package, you probably find that a lot of the time you don't want one bad row to blow up the whole ETL.

You can design your SSIS packages in various ways, but you should always keep your goals and other factors in mind ...

Launch the SSIS Designer application from the Windows Start menu, and then open the existing package containing the Execute SQL task that you wish to change.

Calling an SSIS package from another SSIS package is, on the surface, a simple task. You just use the Execute Package Task and point it to a package on a SQL Server or somewhere in the file system ...