Making more of SSIS in 2008

Integration Services in SQL Server 2008 is Microsoft’s Enterprise Class ETL Tool. In this session I am going to show you how to use it to do so much more than simply taking a table from one database to another. I am going to show you gems like Change Data Capture, Threading models, Fuzzy Logic, Integration with SSAS and SSRS, Lookup transform caching options and what they mean to you. This session is a 400 session so you we will hit the ground running and not stop throughout.

Allan Mitchell

Allan is the joint owner of Konesans Ltd, a small UK based consultancy specializing in SQL Server, and most importantly SQL Server Integration Services. Having been working with SQL Server from 6.5 onwards he has extensive experience in many aspects of SQL Server, but now focuses on the BI suite of tools. He is a SQL Server MVP as well as running the sqldts.com and sqlis.com resource sites.

Allan Mitchell's blog http://www.sqlis.com

---

Downloads

File Type Ext ContentName Zip File .zip Slide Deck

<< 1 >>

---

Other sessions from this conference

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"

2005 SQLCMD Scripting

Administering SQL Server 2008 and 2005 with Windows PowerShell

Development Life Cycle using Visual Studio Team Edition for DB Professionals

Extending SSIS with custom Data Flow components

Getting to grips with Service Broker.

I/O! I/O! It’s off to disk we go...

Introduction to SQL 2008 Performance Data Collector

Making the leap into Advanced SQL

Master Data Management (MDM)

New Product Demos

Recruitment Open Panel

Reporting in SQL Server 2008

SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.

SQL Server 2008 TSQL Enhancements

SQL Server High Availability and Disaster Recovery Overview

Transient data in SQL Server

Understanding LINQ in .NET Framework V3.5 and Beyond

Using Analysis Services as a data source for Reporting Services reports

What Are You Waiting For?

Where do you live? Intro to spatial indexing