Archives: September 2010
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