Home  >  

Tag: ssis

March 14, 2017

Visual Studio 2012 Keeps Crashing

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 try Visual Studio after each step to see if it...

Categories SSIS Comments: 0
February 5, 2014

GnuPG Encryption / Decryption in SSIS 2012

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 was the way to go. Note to Advanced Users : All...

Categories Code Examples/SSIS Comments: 0
August 25, 2012

A connection cannot be made to redirector

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 because the target machine actively refused it. First things first...

Categories SSAS/SSIS Comments: 0
%d bloggers like this: