SSIS: Use those Variables!

    One of the most understated objects that can be used within SSIS is the variable. Variables are accessable through the variables pane within Business Intelligence Development Studio(BIDS). This pane will show you the various variable names, their scope, and also the current value of the variable as shown in the screen shot below.     All of this is pretty rudimentary. You create variables and then assign them values. However, more often than not we would like our routines to be as adaptable as possible and require as little administration as possible. So it would be advantageous to us if we could create dynamic variables that would be evaluated at runtime based upon a set of base variables. Luckily, SSIS enables us to do this quite easily with little if no coding at all required on our part. If you look back to my post Working with SSIS Part #1 , you will see that we use the For Each looping object to loop through a set of Excel files in a directory. I briefly mention that it would be nice to have the files archived after processing in order to keep your working directory clean of file clutter.     We could preform this action rather easily by using a dynamic variable. First we would want to change out For Each loop to only grab the ‘Name and Extension’...

Read More