IT SQL Server Integration Services

Course Code: SQL2INT

Book

Duration

2 Day(s)

Course Type

Public or Private

Max Delegates

12

Delivery Style

Classroom

Enabling you to design and use SQL Server Integration Services projects

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software which can be used to perform a broad range of data migration tasks. It is a powerful export, transformation and load tool. The course will enable delegates to design, deploy and manage Integration Services packages. Packages will be designed using SQL Server Data Tools. This course is suitable for all versions of SQL Server.

Book Your Course

Start Date

Venue

Availability

Cost

29/04/2024

WR1 - Worcester, WR1 3EE

Available

£950*

29/04/2024

Virtual

Available

£950*

Course confirmed - Guaranteed to run
Course Full/Limited availability
Price shown excluding VAT.

Book a Private Event

If you require the content of this event tailored or have around 7 or more people to train it maybe better for you to host a Private Event, please get in touch to discuss this.

Get in touch

Description

Who is this course for

IT professionals who need to build, manage and use Integration Services packages for Microsoft SQL Server.

Purpose of the course

The course includes the important features of Integration Services. For example, connections, control flows, data flows, variables, logging, deployment and error handling. The course is suitable for people who are new to Integration Services. Exercises are included to consolidate the skills taught.

You will learn how to

Develop Integration Services packages
Include control flow tasks, data flows and transformations
Handle data errors
Deploy packages to an Integration Services catalogue
Handle deployment sensitive properties
Use checkpoints to restart packages
Log the progress of Integration Services packages

Prerequisites

No previous knowledge of SQL Server Integration Services is required. A basic knowledge of Microsoft SQL Server is required. This could be gained from our SQL Server Essentials course or through work experience.

Benefits for you as an individual

This course will equip you with the skills to understand and use SQL Server Integration Services. You will have the confidence to develop, deploy and manage Integration Services packages containing both data flows and data transformations.

Benefits for your organisation

SQL Server is increasingly being used to integrate and migrate information to and from a wide variety corporate data sources. This course will give your organisation the ability to develop integration services package to meet these requirements.

A Guided Tour of Integration Services

  • Understanding Integration Services
  • Exploring and Executing an Integration Services
  • Packages in SQL Server Data Tools

Using Control Flows

  • Overview of Control Flow in Integration Services
  • Elements in Control Flow
  • Control Flow Tasks
  • Precedence Constraints

Using Data Flows

  • Data Flow Overview
  • Data Flow Pipeline
  • Data Flow Sources
  • Data Flow Destination
  • Data Viewers
  • Data Transformations

Variables and Parameters

  • Understanding Variables
  • Using Variables in Control Flow
  • Understanding Property Expressions
  • Using Property Expressions
  • Understanding Parameters
  • Using Package and Project Parameters

Error Handling and Package Logging

  • Error Handling and Package Logging Overview
  • Checkpoints
  • Package Logging
  • Event Handling
  • Error Output

Integration Services Deployment

  • Creating an Integration Services Catalogue
  • Overview of Deploying Packages
  • Project Deployment
  • Deployment Wizard
  • Creating Environments
  • Using Environments to Execute Packages
  • Managing Deployment Sensitive Properties

Package Management

  • Overview of Package Management
  • Managing Packages in the Integration Service Catalogue
  • Executing Packages from Management Studio
  • Scheduling Packages with SQL Server Agent
  • Integration Services Security

Get Started

Forget trawling through endless course catalogues – Find the training that’s right for you

Learn More

Latest from our blog

Kanban and Agile: Bridging the Gap

Kanban and Agile: Bridging the Gap Quanta’s Kanban University Certified Trainer Steve Church explores the way in which Agile and…
Read More

How a Ballerina could move into Cybersecurity

Jason Ford, Quanta Cybersecurity and IT Trainer talks about the limitations in Cybersecurity Training courses. Jason discusses a safe and…
Read More

Boost Team Performance and Productivity: Unlocking the Advantages of Emotionally Intelligent Leadership

Quanta People Development and Leadership Trainer, Giles Collins outlines the key elements of Emotionally Intelligent Leadership and how it impacts…
Read More