When attempting to debug some SSIS applications, I encountered a quite annoying issue with my Visual Studio crashing anytime I tried to open a package. To hopefully help someone encountering a similar issue, I decided to list the steps here. Most of these steps are self inclusive, so feel free to […]

Continus reading  

Need a quick way to get the shorthand version (Mmm) of a month in a SSIS expression? Copy and paste the following into a variable and you have precisely just that. A quick code snippet to hopefully save you a couple of minutes of typing. Happy Coding!

Continus reading  

GnuPG (GNU Privacy Guard) is a free implementation of the OpenPGP standard as defined by RFC4880, not to be confused with the proprietary PGP (Pretty Good Privacy) version originally created by Phil Zimmermann. When needing a quick, easy, and free solution to encrypt and decrypt OpenPGP standard files in a SSIS package, GnuPG […]

Continus reading  

I started learning about SQL Server Analysis Services interacting with and using SQL Server Integration Services, and I ran into an issue getting connected to my local server’s Analysis Service. The full error message : A Connection Cannot be made to redirector.Ensure that ‘SQL BROWSER’ Service is running. No connection could be made […]

Continus reading  
%d bloggers like this: