Upgrading SSIS projects, part I

In the previous post, I wrote about migrating SSISDB database. When we migrate the database the packages still have the version of the source SSIS catalog. When you start the execution of the migrated package, you get the information like “The package was migrated from version 6 to version 8. It must be saved to retain migration changes.” This information is written to the log no matter which logging level we choose (also with None). The question is: will it blend should we upgrade the packages (or better – the projects)? And if the answer is ‘yes’ – why should we do it and what are the options? Should we

Share
Continue reading »

Get the passwords from SSIS Environment variables

SSIS has a neat feature – it encodes all the sensitive data when you set it as – well – sensitive. It’s a great thing for environment variables – you write once, use it to configure the project and then you can forget the password. Or write it down for later use. In the future. Some day. Maybe. But what if you need to do the configuration on another server? Or you’re just curious how to decode encrypted data? SSIS has to do it somehow, right?

Share
Continue reading »

What happens during SSIS deployments?

When you deploy SSIS project basically you have two options – right click on project name and standalone tool (let’s skip SMO and stuff). Both mean the same: IsDeploymentWizard.exe. I was curious what happens during deployment and why mode/Silent finishes deployment very quickly, so I started digging.

Share
Continue reading »