I am not quite sure how many of you have tried to set or change the value of a variable using an SSIS script task, but if you have tried I am sure that you may have ran into a few road blocks.  Recently I tried to do this and… Read more

Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group.  My topic was SSIS- Configuration Files, Deployment and a Little Performance Tuning.  The presentation was well received and I hope to have the opportunity to speak to the group again on another occasion. 

Tonight(9/15/2010)… Read more

I was asked by someone the other day, where do you get your drive and motivation? For a second, I was stumped. After giving it a little thought I realized that my drive has several sources. The first is my family of course. My wife has this unbridled drive for… Read more

Puzzle #7 had an interesting twist.  You were required to add a column to the result set that dynamically displayed a currency type based on the existing currency code.  As always, there are a couple of ways to solve this puzzle.  So here is what I started with:

This query… Read more