Managing SSIS Projects through SSMS

re: Managing SSIS Projects through SSMS

ArthurZ — Mon, 26 Mar 2012 20:34:11 GMT

Hello Matt,

When you say when "“Enable automatic execution of Integration Services stored procedures at SQL Server startup” – is checked, an SSIS cleanup job will be executed each time the server instance is restarted.

This cleanup job will fix the status of any packages that were running at the time the instance went down.

When you say "fix the status", does that actually mean the status "executing" will change to "failed" after the restart?

re: Managing SSIS Projects through SSMS

Ayyappan Thangaraj — Thu, 21 Jul 2011 19:22:12 GMT

Thanks Matt for the updates.

re: Managing SSIS Projects through SSMS

Matt Masson - MSFT — Thu, 21 Jul 2011 15:36:04 GMT

Hi Shaun,

It turns out we actually use standard database encryption (not TDE like I thought). I've updated the blog post with the related information.

Thanks!

re: Managing SSIS Projects through SSMS

Shaun Baggett — Thu, 21 Jul 2011 07:39:43 GMT

Hi Matt, your post mentions that SSIS uses Transparent Data Encryption int the catalog. Does this mean that TDE will be available for all SQL versions of Denali that support SSIS as previously TDE was only for Enterprise and Developer editions?