Samples

Webcast: Developing Extensions for SSIS | 2013-05-22

Webcast: Developing Extensions for SSIS | 2013-05-22

Andy Leonard will be joining me to present a Developing Extensions for SSIS webcast on May 22nd. It’s been a long time since I’ve had the chance to present a code heavy session like this, and I’m really looking forward to it. I’ll be using this session as a dry run for a talk I’ll … Continued

Presenting to the .NET Montreal community group | May 27th

Presenting to the .NET Montreal community group | May 27th

The fine folks over at Communauté .NET Montréal have invited me to speak at their meeting on May 27th, 2013. I’ll be using this as a practice run for my sessions at the DevTeach Toronto event later that week. Come join us at the Microsoft Montreal office if you’re interested in finding out more about: … Continued

Refresh an Excel Workbook with a Script Task

Refresh an Excel Workbook with a Script Task

Are you loading data from an Excel workbook with external queries using SSIS? Do you want to make sure those queries are refreshed before the load takes place? Have I got the post for you! I recently had to do this myself, and after some googling with Bing, I found an MSDN forum post that … Continued

EIM presentation material from DevTeach Montreal

EIM presentation material from DevTeach Montreal

I presented an Enterprise Information Manager talk earlier this week at the DevTeach Montreal conference. Unlike my previous talk from TechEd North America, which tackled the problem from the Data Curation (DQS/MDS) side, this talk has a focus on using SSIS to integrate and automate your solution. The demo files are now available from my … Continued

TechEd and the SQL Server 2012 Virtual Labs

TechEd and the SQL Server 2012 Virtual Labs

I had a fantastic time at TechEd North America this year. I didn’t get a chance to attend many sessions, but thankfully they are all recorded – I usually spend a couple of weeks after TechEd crawling through all of the content I didn’t have time to see when I was there. While at the … Continued