SQL Server training     
USACanada UK Ireland International
1 877 849 1850   0808 234 2132   1 800 550 311   +1 678 648 3113
  Home   Contact Us
SQL Server 2005 Training * SSAS Training * SSIS Training * SSRS Training
T-SQL Training * SQL Server 2000 Training* Live Online Training


* SQL Server Training: Introduction to Microsoft SQL Server 2000 Administration
* SQL Server Training: Introduction to Microsoft SQL Server 2005 Administration
* SQL Server 2005: Advanced Topics
* SQL Server 2005 Reporting Services Training: Introduction to SQL Server 2005 Reporting Services
* SQL Server 2005 Analysis Services Training: Introduction to SQL Server 2005 Analysis Services
* SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services
* Transact-SQL Training: Introduction to T-SQL for SQL Server for Report Writing
* T-SQL Training: T-SQL for SQL Server 2005 for Developers
* Live Online Training



Please contact us
for GSA pricing.

GSA

Contract #
GS-35F-0307T



Complimentary SQL Server Training Seminar

Organizations in the Atlanta, Georgia area are encouraged to contact Accelebrate® about having a complimentary, one-hour SQL Server seminar delivered for their developers. Contact us today for more information.



Recent Training Venues

Accelebrate has recently trained for clients in the following cities:

  • Huntsville, Alabama
  • Montgomery / Birmingham, Alabama
  • Anchorage, Alaska
  • Calgary, Alberta
  • Phoenix, Arizona
  • Fayetteville / Little Rock, Arkansas
  • Oakland / San Jose / San Francisco, California
  • Oceanside / San Diego, California
  • Pasadena / Orange County / Los Angeles, California
  • San Bernardino / Riverside, California
  • Boulder / Colorado Springs / Denver, Colorado
  • Washington, DC
  • Wilmington, Delaware
  • Manchester / London, England
  • DeLand / Orlando, Florida
  • Fort Lauderdale / Miami, Florida
  • Gainesville / Jacksonville, Florida
  • Saint Petersburg / Tampa, Florida
  • Titusville & Melbourne, Florida
  • Alpharetta & Atlanta, Georgia
  • Augusta & Savannah, Georgia
  • Macon & Columbus, Georgia
  • Bloomington, Illinois
  • Chicago, Illinois
  • Indianapolis, Indiana
  • Cedar Rapids / Des Moines, Iowa
  • Dublin, Ireland
  • Kingston, Jamaica
  • Wichita, Kansas
  • Paducah / Lexington / Louisville, Kentucky
  • Baton Rouge, Louisiana
  • Valletta, Malta
  • Hagerstown & Frederick, Maryland
  • Greenbelt / Silver Spring / Baltimore, Maryland
  • Boston / Cambridge, Massachusetts
  • Hartford, Connecticut / Springfield, Massachusetts
  • Taunton, Massachusetts / Providence, Rhode Island
  • Ann Arbor / Farmington Hills / Detroit, Michigan
  • Grand Rapids, Michigan
  • Lansing, Michigan
  • Saginaw / Flint / Bay City / Midland, Michigan
  • Saint Paul / Minneapolis, Minnesota
  • Jackson, Mississippi
  • Gulfport / Biloxi, Mississippi
  • Whiteman Air Force Base / Kansas City, Missouri
  • Reno and Las Vegas, Nevada
  • Santa Fe / Albuquerque, New Mexico
  • Newark, New Jersey
  • Princeton, New Jersey & Philadelphia, Pennsylvania
  • White Plains / New York City, New York
  • Charlotte, North Carolina
  • Durham / Raleigh, North Carolina
  • Bowling Green / Toledo, Ohio
  • Cincinnati, Ohio
  • Cleveland & Columbus, Ohio
  • Tulsa / Oklahoma City, Oklahoma
  • Toronto, Ontario
  • Portland, Oregon
  • Pittsburgh, Pennsylvania
  • Providence, Rhode Island
  • Edinburgh / Glasgow, Scotland
  • Columbia & Charleston, South Carolina
  • Memphis / Jackson / Nashville, Tennessee
  • College Station and Houston, Texas
  • El Paso, Texas / Ciudad Juarez, Mexico
  • San Antonio / Austin, Texas
  • Wichita Falls & Dallas, Texas
  • Ogden / Salt Lake City, Utah
  • Burlington, Vermont
  • Fairfax / Dulles / McLean / Herndon / Reston, Virginia
  • Richmond / Alexandria / Arlington, Virginia
  • Virginia Beach / Norfolk, Virginia
  • Tacoma / Seattle, Washington
  • Madison / Milwaukee, Wisconsin

 

 

SQL Server 2005 Integration Services Training: Introduction to SQL Server 2005 Integration Services (SSIS)

Print This Outline
E-mail This Outline
Get A Quote
Course Number: 656
Duration: 3 days
view class outline

SQL Server 2005 Integration Services Training Overview

Accelebrate's Introduction to SQL Server 2005 Integration Services training teaches attendees how to use SSIS to build high performance data integration solutions.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. To receive a customized proposal and price quote, please contact us.

In addition, some courses are available as live, online classes for individuals.  To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/sql.htm.

SQL Server 2005 Integration Services Training Prerequisites

All attendees should have prior experience working with SQL Server 2005.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.

SQL Server 2005 Integration Services Training Materials

All students will receive a copy of McGraw-Hill's Hands-On SQL Server 2005 Integration Services and comprehensive courseware covering all topics taught.

Software Needed on Each Student PC

  • Windows 2000, XP, or Windows 2003 Server
  • SQL Server 2005 full install, including Integration Services
  • At least 768MB RAM (1GB recommended)
  • Other software as mutually agreed upon by the instructor and client -- please contact us for detailed setup instructions

SQL Server 2005 Integration Services Training Objectives

All attendees will learn to:

  • Use BIDS (Business Intelligence Development Studio)
  • Orchestrate control flow and data flow
  • Work with variables and configurations
  • Debug your flows and handle errors
  • Set up sophisticated logging
  • Extend SSIS through custom code
  • Deploy and manage SSIS packages

SQL Server 2005 Integration Services Training Outline

  • Introduction to SQL Server Integration Services
    • Product History
    • SSIS Package Architecture Overview
    • Development and Management Tools
    • Deploying and Managing SSIS Packages
    • Source Control for SSIS Packages
    • Lab: No lab planned for chapter 1
  • SSIS for DBAs: Using SQL Server Management Studio
    • The Import and Export Wizard
    • Database Maintenance Plans
    • Lab: Creating and scheduling a database maintenance plan
  • A Guided tour of Business Intelligence Development Studio
    • Launching BIDS
    • Project templates – creating and opening SSIS projects
    • The package designer
    • The Toolbox
    • Solution Explorer
    • The Properties window
    • The Variables window
    • The SSIS menu
  • Introduction to Control Flow
    • Control Flow Overview
    • Precedence Constraints
    • The Execute SQL Task
    • The Bulk Insert Task
    • The File System Task
    • The FTP Task
    • The Send Mail Task
    • Lab: Creating a Simple SSIS Package
  • Advanced Control Flow
    • Containers – grouping and looping
    • The Web Service Task
    • The WMI tasks
    • The Analysis Services tasks
    • The Execute Process Task
    • The Execute Package Task
    • Lab: Creating a master/child package
  • Introduction to Data Flow
    • Data Flow Overview
    • Data Sources
    • Data Destinations
    • Data Transformations
    • The Copy Column Transformation
    • The Derived Column Transformation
    • The Data Conversion Transformation
    • The Conditional Split Transformation
    • The Aggregate Transformation
    • The Sort Transformation
    • Data Viewers
    • Lab: Integrating Control Flow and Data Flow
  • Variables and Configurations
    • Variables Overview
    • Variable scope
    • SSIS system variables
    • Using variables in control flow
    • Using variables in data flow
    • Using variables to pass information between packages
    • Property expressions
    • Configuration Overview
    • Configuration options
    • Configuration discipline
    • Lab: Creating a configured SSIS package
  • Debugging, Error Handling and Logging
    • SSIS debugging overview
    • Breakpoints in SSIS
    • SSIS debugging windows
    • Control Flow: The OnError event handler
    • Data Flow: Error data flow
    • Configuring Package Logging
    • Built-in log providers
    • Lab: Handling data and execution errors
  • Advanced Data Flow
    • Revisiting data sources and destinations
    • The Lookup Transformation
    • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
    • The Multicast Transformation
    • The Merge and Merge Join Transformations
    • The Data Mining Query Transformation
    • The Data Mining Model Training Destination
    • The Slowly Changing Dimension Transformation
    • Lab: Working with lookups
  • Extending SSIS through Custom Code – An Introduction to Custom Components and Scripting
    • Introduction to SSIS scripting
    • The SSIS script editor
    • The SSIS object model
    • Script in Control flow: The Script Task
    • Script in Data flow: The Script Component
    • Introduction to SSIS component development
    • Lab: Creating a custom transformation by using the Script Component
  • SSIS Package Deployment
    • Configurations and deployment
    • The deployment utility
    • Deployment options
    • Deployment security
    • Executing packages – DTExec and DTExecUI
    • Lab: Deploying a package with the deployment utility
  • SSIS Package Management
    • The SSIS Service
    • Managing packages with DTUtil
    • Managing packages with SQL Server Management Studio
    • Scheduling packages with SQL Server Agent
  • Conclusion
 
Print This OutlineE-mail This OutlineGet A Quote
Accelebrate®
Comes to You!


Accelebrate's courses are taught exclusively on-site at your location for groups of 3 or more attendees, anywhere worldwide.

Don't settle for a "one size fits all" public class! Have Accelebrate come to your site and deliver exactly the training you want, for less than the cost of a public class.

For pricing and to learn more, please call us at +1 877 849 1850, fill out our information request form, or email us at info@accelebrate.com today.
 
Accelebrate E-Newsletter


Get the latest Web development news delivered to your email box once a month!

 
I've taken alot of classes and [the instructor] doesn't just read from the book; he explains the material in easy to understand terminology.
 
—Lori Speakman
UNC - Wilmington
Wilmington, North Carolina

VB.NET, C#, ASP, & ASP.NET Training * Java Training * SQL Server Training
Adobe Training * PHP Training * XML Training * Perl Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003-2006 by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.

Recent client sites: Birmingham, AL | Phoenix, AZ | Los Angeles, CA | San Diego, CA | San Francisco, CA | Denver, CO | Washington, DC | Miami, FL | Orlando, FL | Tampa, FL | Atlanta, GA | Chicago, IL | Indianapolis, IN | Boston, MA | Baltimore, MD | Detroit, MI | Minneapolis, MN | Kansas City, MO | Saint Louis, MO | Charlotte, NC | Raleigh, NC | Albuquerque, NM | New York City, NY | Cincinnati, OH | Cleveland, OH | Columbus, OH | Oklahoma City, OK | Toronto, ON | Philadelphia, PA | Pittsburgh, PA | Portland, OR | Memphis, TN | Nashville, TN | Austin, TX | Dallas, TX | Houston, TX | Salt Lake City, UT | Seattle, WA | Dublin, Ireland | London, UK
About Accelebrate IT Training VB.NET, C#, and ASP.NET Training Java, Struts, and JSP Training Adobe Training Microsoft SQL Server Training XML Training, PHP Training, Perl Training, and Other Courses Open Source & Apache Training