I’m mentally preparing myself for a whole slew of upcoming conferences / speaking engagements over the next month and a... ...
Presentations Galore!
Welcome to my blog!
SQL Server Integration Services (SSIS), Enterprise Information Management (EIM) and general Data Movement
Presentations Galore!
I’m mentally preparing myself for a whole slew of upcoming conferences / speaking engagements over the next month and a half. I love talking about SQL Server technologies, and I’m honored that I’ll have so many chances to do it in the next few weeks! Please come see me at one (or more) of the following events: 05/22 – Webcast: Developing Extensions for SSIS 05/27 – Montreal User Group 05/30 – DevTeach Conference in Toronto, Ontario 05/31 – EIM Training in Toronto, Ontario 06/03 – TechEd North...
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...
Windows Azure Application Gateway
Background I'm not sure when it started, but for a while now I've found it hard to just sit and watch TV or a movie with my family. I feel like it doesn't occupy my mind enough, and I need to...
How to Localize Your Custom Connection Manager
Similar to localizing a task, you can localize the display name and description of a custom connection manager by setting the LocalizationType property of the DtsConnection attribute. SSIS will look for two properties on the class: ConnectionDescription ConnectionDisplayName These must be public, static string properties on your LocalizationType class. The code looks like...
SSIS, DQS and MDS Training at SQL Saturday #229 | Dublin, Ireland
I’m honored to be invited back to this year’s SQL Saturday Dublin event. I must have done a decent job last year on my SSIS Design Patterns pre-conference session, because I’ve been asked to do another one this time around as part of their Training Day (June 21st). This year I’ll be doing a full day training session on Enterprise Information Management, which greatly expands upon one of my more popular talks about combining SSIS, DQS and MDS....
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...
Using Data Explorer with SSIS
Data Explorer is a great new add-on for Excel. It provides a simple interface over a power data transformation engine (powered by M), and it has become my tool of choice anytime I need to get data into Excel. In...
Error: The Microsoft Access database engine cannot open or write to the file
Issue – you run an SSIS package that uses an Excel Source or Excel Destination and get the following error: Steps to resolve: Verify that the file isn’t actual open (check task manager for suspicious EXCEL.EXE processes) Verify that there are no other SSIS packages (or other background processes) that might be opening this file at the same time If you are in Visual Studio...
Monitoring SSIS package executions
Question: When we run SSIS in development (from SSDT/BIDS), we can see the progress of the job, with all of the steps highlighted in yellow, red or green. Is there a way to display this same status information when the packages run in production? You have a number of options when it comes to monitoring SSIS packages at runtime. In 2005/2008, you needed to create your own solution (based on SSIS logging, or custom logging approaches). In 2012, you now have...
Consuming CANSIM Datasets using Data Explorer
I recently stumbled upon CANSIM – Canada’s equivalent of Data.Gov. The site has a lot of really interesting datasets that come in handy if you’re someone who frequently creates data focused demos. I wanted to play around a bit more...
Using OUTPUT Parameters with the OLE DB Source
Did you know that support for OUTPUT parameters was added to the OLE DB Source in SSIS 2012? So many features were added in 2012, this one is often overlooked. (I had completely forgotten about it until someone asked the...
Slides from SSIS Performance Design Patterns | TechDays Hong Kong 2013
The slides from my 3rd presentation at the TechDays Hong Kong event are now available. As I mentioned during the talk, design patterns are one of my favorite topics, and something I really enjoyed writing about. This presentation had a subset of the SSIS Performance Design patterns in the full day training sessions I’ve done in the past. See this post for a link to the full deck (over 100 slides). Thanks for...
Slides from Bringing Together SSIS, DQS and MDS | TechDays Hong Kong 2013
A big thank you to everyone who attended my 2nd session at the TechDays Hong Kong event, Enterprise Information Management (EIM): Bringing Together SQL Server Integration Services (SSIS), Data Quality Services (DQS) and Master Data Services (MDS) (wow that’s a long title). The slides are available below. The files for my integrated demo are available on my skydrive share. Note, this session is very similar to the one I did at DevTeach Montreal and the 2012 PASS Summit (when I co-presented...
Slides from SSIS with Oracle talk | TechDays Hong Kong 2013
The slides from the Using SQL Server Integration Services with Oracle talk from TechDays Hong Kong 2013 can be found below (use the embedded control to download the powerpoint presentation directly from SkyDrive). Thank you to everyone who...