Presenting at SQL Saturday #172 | Oregon

I’ll be co-presenting a couple of sessions at SQL Saturday #172 in Portland, Oregon this weekend (11/3). The lineup for this event looks great, with a lot of speakers who will also be at the PASS Summit the following week.

First up is an SSIS session with SSIS Design Pattern co-author Tim Mitchell (Blog | Twitter).

SSIS Incremental Load Design Patterns

In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing.

At the end of the day I will be co-presenting a hybrid data movement talk with fellow MS employee, Adam Larson.

Efficient On-Premise to Cloud Data Transfer

Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you! We’ll cover some common user scenarios, and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.

Hope to see you there!

 

Slides from DQS presentation

A big thank you to everyone who came to tonight’s DQS presentation for the New England SQL Server User Group. As promised, you can find the slides on my skydrive share (as well as embedded below). I also wanted to list some of the great DQS resources mentioned in the talk:

 

Encrypting Sensitive Properties in a Custom Connection Manager

SSIS provides a mechanism to automatically encrypt the sensitive properties of your Connection Manager (or Task) based on the package ProtectionLevel. To make use of this in your custom code, you’ll need to do two things:

  1. Implement the IDTSComponentPersist interface
  2. Add a Sensitive=”1” attribute to one or more elements of your persisted Connection Manager (or Task)

Sample code:

How to Localize Your Custom Task

The DtsTask attribute has a LocalizationType member. This should be your resource class. SSIS will look for two properties:

  • TaskDisplayName
  • TaskDescription

These must be public, static string properties on your “LocalizationType” class.

Your task code would look like this:

You can add localizable string resources to your class from the Project settings:

clip_image001

Note, the Access Modifier must be set to Public.

Double note (as I hit this when putting together the blog post) – in SQL 2012, when you first add a new task to your <sql>110DTSTasks directory, you can right click on the SSIS Toolbox and select Refresh Toolbox to make it show up.

clip_image002

If your LocalizationType settings are incorrect (for example, you forgot to set the Access Modified to Public), your task will show up with an empty name. You must fix your class and rebuild, but you’ll need to restart Visual Studio before the changes take effect (as the class has been instantiated, SSIS will have the old object cached…).

My Sessions at the 2012 PASS Summit

TechEd has its appeal, but of all of the conferences I attend, I must admit that I love the PASS Summit most. I look forward to it every year. The event is physically and mentally exhausting, but I always come home feeling refreshed and inspired. I really enjoy meeting people who use the products I work on, hearing about their issues, and trying to help them out as much as I can.

My schedule this year is even more hectic than previous years, with three breakout sessions and a pre-con event. I’m co-presenting each of my sessions with talented Microsoft folks, and have been busy working on putting the finishing touches on my talks to ensure my audience is entertained (they might even learn something, too).

SSIS Design Patterns [BIA-299-P]

This is the SSIS pre-con event that I previously posted about. The day will be split between the five authors of the SSIS Design Patterns book that came out last month.

In this full-day session, the "SSIS Design Patterns" (Apress, 2012) author team – Matt Masson, Tim Mitchell, Jessica M. Moss, Michelle Ufford, and Andy Leonard – will describe and demonstrate patterns for package execution, package logging, loading flat file and XML sources, loading the cloud, dynamic package generation, SSIS Frameworks, data warehouse ETL, and data flow performance.

Data in the Sky: Efficient On-Premise to Cloud Data Transfer [CLD-306-M]

Co-presenting with Wee Hyong Tok, a PM from the SSIS team. If you’ve seen any of my SSIS presentations in the past, you’ve probably seen Wee Hyong’s material before – I love stealing his slides as my own.

Thinking about moving some of your operations to Azure? Have multiple remote sites, and want to use the cloud to centralize and share data between them?? Just like hearing talks about data transfer performance?! Have we got the session for you!
We’ll cover some common user scenarios and describe when and how to use the latest Microsoft data transfer technologies, including SQL Server Integration Services (SSIS), SQL Data Sync (a capability of SQL Database), and more.

Enterprise Information Management: Bringing Together SSIS, DQS, and MDS [BIA-316-M]

Matthew Roche and I will be presenting a follow-up to our TechEd presentation with some new and interesting integration scenarios.

Enterprise Information Management (EIM) – an industry term for managing your data for data integration, quality, and governance – is an important part of the SQL Server 2012 release. This session revolves around a demo that brings together the EIM functionality in SQL Server 2012 and tells the "Credible, Consistent Data" story. You will see how SQL Server Integration Services (SSIS), Data Quality Services (DQS), Master Data Services (MDS), and other Microsoft technologies work together to provide a comprehensive EIM solution.

BI Power Hour [BIA-206-M]

Back by popular demand – I actually had a reviewer give me a bad score in my PASS session last year because we didn’t have a BI Power Hour session! My fault for trying to make the audience laugh by showing them my demos from TechEd… We have a new lineup of speakers for PASS, as well as some old favorites. This one will be great – of all of the presentations I do in a year, this is the one I enjoy most!

The legacy continues. The Microsoft Business Intelligence team is excited to once again present the BI Power Hour. In this entertaining session, we dazzle you with new demonstrations that expose the lighter side of BI while highlighting the flexibility and power of the Microsoft BI Platform. If you’ve never been to a Power Hour session, you don’t know what you’ve been missing. We promise you’ll walk away impressed – and with a smile on your face.

Automatically Select Input Columns in a Custom Data Flow Component

The following code snippet can be used in a custom data flow component to automatically select all input columns when you attach a path.

This is the equivalent to clicking the Select All box in the Advanced Editor.

image