I finally have an opportunity to get out to see one of our manufacturing plants in Calgary in mid-March, and as part of that road trip, I've arranged to present at the Calgary PASS chapter. I've been talking to Noel Tan on and off for a few months, and he's graciously agreed to let me bore the pants off his prairie brethren with some Integration Services claptrap.
What
I'll be doing an SSIS topic - or maybe two, depending on how indulgent the crowd is on that night. We'll start off with Diagnosing and Addressing Performance in SSIS, and if we make it through that one with most of the audience awake, we'll take a caffeine break then jump In-Depth with the SSIS Script Component. To expand upon those vague titles, here's what's in store:
Diagnosing and Addressing Performance in SSIS
Integration Services is a complex system of parallelism and in-memory buffers. Determining what parts of your package are causing sub-par performance requires some specific techniques. Before you apply any "top ten" performance enhancements, you need to identify where the issue is - or you'll be wasting your time. Learn what tools are available for monitoring and diagnosing poor performance in SSIS packages and how to apply them. Dive in to the only technique to diagnose Data Flow bottlenecks - decomposition - and how to effectively address the most common causes.
In-Depth with the SSIS Script Component
The Script component is the Swiss Army knife of data transformation in Integration Services. If there isn't a built-in transformation that will parse, reformat, restructure, or otherwise mash your data the way you need, then you should look to the Script transform. The Script component has access to SSIS variables, connections, and all of the columns in the data flow. It can act as a data source (perhaps reading information from a web service), a destination (maybe writing to an EDI text file), or a transformation (possibly encrypting a column's contents). The Script component has full access to the .Net Framework, so the possibilities are endless. But there are a lot of ground rules a .Net developer or IS package developer needs to know before they can effectively solve problems with the Script. Learn what you need to know.
When
The Calgary chapter doesn't have monthly meetings - I interpret that to mean that every meeting is a special event! This special event takes place Wednesday, March 17th (St. Patrick's Day) - 5th Floor, 715-5th Avenue SW. I hope to see you there, and perhaps after to find some green barley sandwiches...
UPDATE: Materials are on SkyDrive.
No comments:
Post a Comment