Although you can trigger a job within SQL Agent from Control M, you then have the complexity of getting the Control M job to wait until the SQL Agent job...

The Microsoft one only handles SQL 2005 SSIS Packages.

There is now an SQL 2005/2008 version available on Codeplex.

http://sqlmetadata.codeplex.com

The following is a regex that handles the edge cases that were presented earlier, BUT if you use it with regex replace, you will lose that ugly comments between CREATE...

I never did find a solution. I capture the output from the package execution and store that for diagnostics if the ftp step reports an error.

There are third party...