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 I quickly realized that it is not as straightforward as I thought. To do this configure your package so that you have a source of some type on the data flow design surface. Drag a script task onto the data flow and connect it to the source. Typically, you would set the varia...
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) I will be speaking in front of my local SQL Server User Group in Baton Rouge. The topic is Loading a Data Warehouse with SSIS. In addition, I will doing a short presentation (Lightni...
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 success that cannot be measured at any level. Whenever anyone in the house says I can’t, I don’t know how to…, You can’t or some variation of those sentences she immediately corrects us. Can’t is not part of our vocabulary. Next it’s my ki...
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 satisfies most of the requirements, but one thing you should notice here is the tuple. I started out here with only the Country and State-Province, which I thought would work. Then I added the following calculated member: In the ...