There are a lot of different ways to run SSIS packages , and many situations call for a custom package launcher application. If you're coding your own launcher, one thing to keep in mind is that certain SSIS functionality (such as the Script task / component...

I recently helped with a customer issue where they had a long running stored procedure which output status messages periodically using PRINT statements. They wanted to capture these statements and output them into the SSIS log. Unfortunately, the Execute...