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 »

SQLBits 2017

This year I attended SQLBits for the first time. I wanted to go to the event last year, but didn’t manage, so this time it was a must. And I have to tell you – great event in all aspects. First – the content I wanted to learn something new, or look at the things from different angle. Touch something, break and repair. So I went for the workshop by Mark Broadbent (b|t) about high availability with clusters and Always On Availability Groups. I did play with clusters before (using VirtualBox), this time we used Hyper-V and Windows Core servers what was new for me. Building from the ground up,

Share
Continue reading »