Helpful information and examples on how to use SQL Server Integration Services.
I flew to Tucson last week to record my sessions for the upcoming SSWUG.ORG Spring Virtual Conference. I recorded three sessions for the BI track:
How to Avoid Common Pitfalls with SSIS
Starting up a new project with SQL Server Integration Services? Save time and money by learning about how to avoid common issues that users hit when implementing their ETL solutions. Drawing on the most frequently asked questions in the MSDN Integration Services forum and some of the more interesting packages we've seen over the years, we'll highlight common mistakes, clear up some misconceptions, and provide best practices to help you efficiently and effectively use Integration Services.
Incremental Data Warehouse Loads with MERGE and Change Data Capture
This talk describes the new MERGE statement and Change Data Capture (CDC) feature introduced in SQL Server 2008, and how to take advantage of them in SQL Server Integration Services. We'll cover the traditional ways of doing incremental data loads, and see how these new key features make the process a whole lot easier. If you're interested in learning best practices for this new SQL Server 2008 functionality, you won't want to miss this session!
New Connectivity Options in SSIS 2008
Figuring out the best way to connect to your data sources can be tricky. SQL Server Integration Services 2008 has made it easier with the addition of new high performance connectors for Oracle, Teradata, and SAP BI. This talk will walk through their features, and take a look at how they can drastically improve the performance of your data loads.
They put together a very impressive list of speakers again (I’m still surprised – and honored – to see my name next to these people!), and the sessions look pretty good as well. I’m sure I’ll be attending a number of the sessions myself. Some of the other SSIS ones include:
Anthony D'Angelo - Deep Dive: Extending SSIS with .NET Development
Brian Knight - Dynamically Configuring SSIS packages, Loading a Data Warehouse in SSIS, Performance Tuning SSIS 2005 and 2008
John Welch - Doing More (ETL) with Less (Effort) by Automating SSIS, Processing Flat Files with SSIS
Ted Malone - Agile Business Intelligence - Proven Techniques that move BI Development into the Agile World
They still have an early bird registration rate going, and you can use the vip code SPVMMASP09 to get an additional discount. The conference runs from April 22-24th… hope to see you there!
They’ve posted 10 minute previews for some of the talks at the upcoming SSWUG.ORG Virtual Conference