Integration services in sql server 2008 l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 19

Integration Services in SQL Server 2008 PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on
  • Presentation posted in: General

Integration Services in SQL Server 2008. Allan Mitchell – SQLBits – Oct 2007. Introduction. New threading architecture Pipeline limiter (not really new!) New Tasks/Components/Enumerators C# Change Control routines for data extraction Q and A. Who am I?. SQL Server MVP

Download Presentation

Integration Services in SQL Server 2008

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Integration services in sql server 2008 l.jpg

Integration Services in SQL Server 2008

Allan Mitchell – SQLBits – Oct 2007


Introduction l.jpg

Introduction

  • New threading architecture

  • Pipeline limiter (not really new!)

  • New Tasks/Components/Enumerators

  • C#

  • Change Control routines for data extraction

  • Q and A


Who am i l.jpg

Who am I?

  • SQL Server MVP

  • Co author on Wrox book on SSIS

  • www.SQLDTS.com, www.SQLIS.com

  • Consultancy company – Konesans (www.konesans.com)


What i will not cover l.jpg

What I will not cover

  • Finding SSIS

  • Creating packages

  • General package design


Threading l.jpg

Threading

  • How is it now?

    • Some processes use single threads

  • Why is this not brilliant?

    • Sync Outputs with a blocking transform on one of the outputs kills performance

  • What is coming?

    • Threading model changed to allow components to go out and try to get their own thread

  • Why will this help?

    • Takes advantage of today’s bigger, faster boxes


Slide6 l.jpg

DEMO


Pipeline limiter l.jpg

Pipeline Limiter

  • Why would they want to slow me down?

    • Fill buffers and run out of memory

  • I see it now in SQL Server 2005? Really?

    • You see it but SSIS keeps quiet


Slide8 l.jpg

DEMO


New tasks and components l.jpg

New Tasks and Components

(Data Collector Specific)

  • Tasks

    • Update Row Counts

    • Reset Row Counts

    • Trace Start Script

    • Cache Window Maintenance

  • Components

    • TxPerfCounters


New enumerator s l.jpg

New Enumerator (s)

  • ForEach Database Enumerator

    • Uses OLEDB for connection

    • Configure what DBs you enumerate (see next slide)

    • Rubbish UI experience


Db enumeration types l.jpg

DB Enumeration Types

DBENUM_CUSTOM = 0

DBENUM_SYSTEMONLY = 1

DBENUM_USERONLY = 2

DBENUM_ALL = 3


Slide12 l.jpg

DEMO


Slide13 l.jpg

C# !

  • Script Component

  • Script Task

  • Custom component development has always been available in C#


Demo quick look l.jpg

DEMO (Quick Look)


Slide15 l.jpg

Using New DB Change Control

  • Billed as an ETL feature

  • We’ll use it if it’s there

  • What is it?

  • How do I use it then?


What and why l.jpg

What and Why

  • Increased efficiency of ETL Process

  • Incremental Extractions

  • Identify changed rows and columns

  • Identify operation on data, all changes or net changes

  • Log Based (Transactional Replication LR)

  • Lightweight


Terminology l.jpg

Terminology

  • Capture Instance – Base Object (Max 2 per object)

  • Capture Process – Reading of the log and placing the rows into the change tables


Slide18 l.jpg

DEMO


Questions l.jpg

Questions?

Email: [email protected]


  • Login