Discover Classes. Earn 10% Rewards.

SQL Server Integration Services is unfortunately unavailable

Thankfully we have 163 other Microsoft Classes for you to choose from. Check our top choices below or see all classes for more options.

MS Copilot Training: from Basics to Mastery

Prompt Yes! See all classes by this school

Develop practical AI skills that streamline everyday office tasks and boost productivity across a wide range of workplace scenarios. Through hands-on guidance and real-world applications, you'll gain the confidence to use intelligent tools more effectively and efficiently in your daily workflow.

(68) Intermediate 18 and older
$495
Attend
+4950 pts
Gift it!

SQL Server Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Pick up actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Push your data analysis skills to a new level.

(452) All levels 18 and older
$975

3 sessions

Gift it!

Power BI Bootcamp

Noble Desktop See all classes by this school - Virtually Online

Develop expert-level data storytelling skills by learning to build dynamic visualizations and sophisticated dashboards in Power BI. Connect multiple data sources, leverage Power Query for efficient data shaping, and apply Power BI's time intelligence reports to uncover trends over time. A thorough, career-elevating course for business reporting professionals.

(452) All levels 18 and older
$799

2 sessions

Gift it!

Power BI Advanced

Noble Desktop See all classes by this school @ Zoom Conference

This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.

(452) All levels All ages

Microsoft Windows

Computer Training Source, Inc. See all classes by this school @ Online Classroom

Get into the ins and outs of Microsoft Windows, the operating system at the heart of most computers today. Lift your productivity by learning how to navigate the desktop, customize settings, organize files, and run system maintenance. Discover the power of keyboard shortcuts and strengthen your overall computer skills in this comprehensive course.

(22) Beginner 18 and older
$299
Attend
+2990 pts
Gift it!
See all Microsoft classes Online

SQL Server Integration Services

  • All levels
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Live, Interactive Online Classroom
  • 40 hours over 5 sessions

Start Dates (0) $2,975/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

Who should attend

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Prerequisites

  • Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

Course Objectives

  • Create sophisticated SSIS packages for extracting, transforming, and loading data
  • Use containers to efficiently control repetitive tasks and transactions
  • Configure packages to dynamically adapt to environment changes
  • Use Data Quality Services to cleanse data
  • Successfully troubleshoot packages
  • Create and Manage the SSIS Catalog
  • Deploy, configure, and schedule packages
  • Secure the SSIS Catalog

Course Outline: 

1 - SSIS Overview

  • Import/Export Wizard
  • Exporting Data with the Wizard
  • Common Import Concerns
  • Quality Checking Imported/Exported Data

2 - Working with Solutions and Projects

  • Working with SQL Server Data Tools
  • Understanding Solutions and Projects
  • Working with the Visual Studio Interface

3 - Basic Control Flow

  • Working with Tasks
  • Understanding Precedence Constraints
  • Annotating Packages
  • Grouping Tasks
  • Package and Task Properties
  • Connection Managers
  • Favorite Tasks

4 - Common Tasks

  • Analysis Services Processing
  • Data Profiling Task
  • Execute Package Task
  • Execute Process Task
  • Expression Task
  • File System Task
  • FTP Task
  • Hadoop Task
  • Script Task Introduction
  • Send Mail Task
  • Web Service Task
  • XML Task

5 - Data Flow Sources and Destinations

  • The Data Flow Task
  • The Data Flow SSIS Toolbox
  • Working with Data Sources
  • SSIS Data Sources
  • Working with Data Destinations
  • SSIS Data Destinations

6 - Data Flow Transformations

  • Transformations
  • Configuring Transformations

7 - Making Packages Dynamic

  • Features for Making Packages Dynamic
  • Package Parameters
  • Project Parameters
  • Variables
  • SQL Parameters
  • Expressions in Tasks
  • Expressions in Connection Managers
  • After Deployment
  • How It All Fits Together

8 - Containers

  • Sequence Containers
  • For Loop Containers
  • Foreach Loop Containers

9 - Troubleshooting and Package Reliability

  • Understanding MaximumErrorCount
  • Breakpoints
  • Redirecting Error Rows
  • Logging
  • Event Handlers
  • Using Checkpoints
  • Transactions

10 - Deploying to the SSIS Catalog

  • The SSIS Catalog
  • Deploying Projects
  • Working with Environments
  • Executing Packages in SSMS
  • Executing Packages from the Command Line
  • Deployment Model Differences

11 - Installing and Administering SSIS

  • Installing SSIS
  • Upgrading SSIS
  • Managing the SSIS Catalog
  • Viewing Built-in SSIS Reports
  • Managing SSIS Logging and Operation Histories
  • Automating Package Execution

12 - Securing the SSIS Catalog

  • Principals
  • Securables
  • Grantable Permissions
  • Granting Permissions
  • Configuring Proxy Accounts

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

Cancellation Policy:

Public Classes

All requests to cancel a registration must be in writing via e-mail to [email protected]

  • You may cancel 11 or more business days from the start of the class for a refund less 5% cancellation fee.
  • If you cancel less than 11 business days from the start of the class, you are responsible for 100% of the course fee.

Cisco Data Center or Cisco Cloud Courses

All requests to cancel a Cisco Data Center or Cisco Cloud class reservation must be made via e-mail.

  • You may cancel or reschedule more than 19 business days from the start of the class for a refund less 5% cancellation fee.
  • If a Learner chooses to reschedule, the payment already received will be applied to the new class.
  • If a cancellation request is made within 19 business days of the class start date, no refund will be provided, regardless of payment method.

Partner-Delivered Classes

For Partner-delivered courses, if a reservation is canceled or rescheduled fewer than 16 business days before the class start date, the entire original course fee will be forfeited. An additional course fee will be required for the new reservation.


*The school, or one of its Partners, reserves the right to cancel a course for any reason and without penalty more than ten (10) business days before the start of the class.


Rescheduling:

All requests to reschedule a registration must be in writing via e-mail to [email protected]

Public Classes

  • Students may reschedule a registration up to 11 business days before the scheduled start date without penalty.
  • Rescheduling will be defined as transferring the registration to the same course on a different date or transferring to another course of equal or lesser value up to 6 months from the original course start date.

Partner Delivered Classes

  • For Partner delivered courses, if a student reschedules less than 16 business days before the class, the entire original course fee may be forfeited. An additional course fee may be required for the new registration.


* You are allowed two (2) reschedules. After a second reschedule, the entire original course fee will be forfeited, and an additional course fee will be required for a new registration.


No Shows:

Failure to attend without prior written notice to the start date of the course will be considered a "no show" and will result in forfeiture of the full course price including NetApp courses paid for with NetApp Training Units. Under these conditions, the school, at its own discretion may allow you to re-sit another session of the same or lower priced course.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 29750 points. Earn 10% back in reward points!

Fast Lane - New York

Fast Lane, a leading provider of advanced IT training courses, offers complete authorized training solutions for Cisco, NetApp, VMware and more. We are a proud developer of new advanced technology courses to ensure your access to the most updated training for your career.

Fast Lane’s instructor-led...

View school profile
Fast Lane - New York
Vetted by CourseHorse

A verified Online educator.

Loading...