SSIS – Tech Talk

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...

SSIS Comments: 0

January 24, 2017

Fixing “There is an invalid number of result bindings returned for the ResultSetType: ResultSetType_SingleRow”

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 had created an Execute SQL Task and set the Result...

SSIS Comments: 2

June 9, 2014

Shorthand Month in SSIS Expression

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!

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...

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...

SSAS/SSIS Comments: 0

August 25, 2012

Error: 0xC0048006 at [Process Name], ActiveX Script Task: Retrieving the file name for a component failed

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 failed with error code 0x05AA8FA4. Confused, I found a few...

SSIS Comments: 0

Category: SSIS

Visual Studio 2012 Keeps Crashing

Fixing “There is an invalid number of result bindings returned for the ResultSetType: ResultSetType_SingleRow”

Shorthand Month in SSIS Expression

GnuPG Encryption / Decryption in SSIS 2012

A connection cannot be made to redirector

Error: 0xC0048006 at [Process Name], ActiveX Script Task: Retrieving the file name for a component failed