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  

Sometimes when rushing through setting up a project we tend to forget to configure things, then are perplexed by the error messages since they don’t always give you exactly where to look or what property you missed. This recently happened to me in SSIS with the Execute SQL Task. I […]

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  

When I was testing a SSIS package that usually runs on a server, I got the following error during a process which is supposed to copy a file to a folder on a  different server. Error: 0xC0048006 at [Process Name], ActiveX Script Task: Retrieving the file name for a component […]

Continus reading  
%d bloggers like this: