Darren Herbold

SSIS variables in Data Flow Script Component in Milwaukee

While at a client in Milwaukee, I came upon an interesting problem on how to access a
user-defined variable in a Script Component in the Data Flow. There are actually two ways
to solve this problem. One technique is to place a Derived Column before the Script component
and create a new derived column using the variable as the expression. This will create a new
column in the data pipeline with the value of the variable as its value.

The other technique is to use the "Me" namespace in VB.NET directly in the Script Component
script code. The syntax will be as follows: Me.Variables.<variableName>. So if the variable name
was called myVar, the syntax would read: Me.Variables.myVar
One last thing you need to do is double click the Script Component to open the editor and under
the Script menu item, set the variable you wish to use in your script here:

I happened to be there in the Winter time so it was fiercely cold and I mean cold beyond
comprehension. The first day I got there it was -27. That's right, NEGATIVE 27. I knew
I was in trouble when I overheard to guys in the elevator having a conversion that went
something to the effect of:

Guy1: Wow, it's cold today.

Guy2: Yeah, but tomorrow its going to warm up and snow.

That's what he said, no kidding. Warm Up, AND SNOW!! Apparently it was TOO COLD
to snow! How crazy is that?!?!

Anyway, here are some pictures I took during my tenure there:

This is the view from the client's office. That's Lake Michigan, FROZEN.