SQL Server Integrations Services - SSIS (online)
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Class hours
12h
-
Duration
2 Days
-
Start date
Different dates available
-
Delivery of study materials
Yes
-
Support service
Yes
-
Personal tutor
Yes
-
Virtual classes
Yes
SQL Server Integration Services (often abbreviated to SSIS) allows you to automate the import, export and conversion of data. Whether you want to fill your data warehouse each evening with that day's transactions (whatever they may be) - or simply learn how SSIS fits into the wider SQL Server picture - this course is for you!
Refreshingly, the course doesn't use any large, impenetrable Microsoft database, but instead uses a simple Wise Owl one, and the exercises use simulated examples of real-life tasks.
Important information
Documents
- Introduction to SSIS course outline.pdf
Facilities
Location
Start date
Start date
Reviews
Subjects
- SSIS basics
- Data flow tasks
- Using different data connections
- Data viewers
- Basic data transforms
- Data conversion transforms
- Variables and expressions
- Debugging
- Derived column transforms
- Handling Errors
- Conditional split transforms
- Lookup transforms
- File system tasks
- Looping over files
- Importing multiple files
Teachers and trainers (4)
Andrew Gould
Senior Trainer
Andy Brown
Microsoft Trainer & Programmer
Sam Lowrie
Trainer
Shaun Wantling
Trainer
Course programme
- Solutions and projects
- Basic packages
- Control and data flow tasks
- The 32-bit question
- Connection managers
- Sources and destinations
- SQL Server (OLEDB)
- Connecting to Excel workbooks
- New and existing flat files
- Multiple flat files
- Attaching data viewers
- Data buffers
- Sorting and aggregating
- Sampling data
- Dividing and uniting data
- The SSIS data types
- Unicode and ASCII data
- Type cast functions
- The Row Count transform
- User and system variables
- Expression tasks
- Setting breakpoints
- The Locals window
- SSIS expressions
- Using SSIS functions
- Using the conditional operator
- Redirecting and ignoring errors
- Truncation errors
- Splitting data by expression
- Using comparison operators
- Syntax for multiple conditions
- Redirecting unmatched rows
- Choosing a cache mode
- Setting unmatched rows to Unknown
- Adding unmatched rows automatically
- Working with files
- Working with folders
- The file name variable
- Configuring the loop
- Expression constraints
- Using expressions for connections
- Dynamic connections within loops
If time
Looping over rows- Object variables
- Reading in data
- Looping over ADO rows
- Dynamic connection strings
- Using the ? Symbol
- Mapping parameters
- How they work
- Comparing two data sets
- Project-level deployment
- Creating a catalog
- Deploying and viewing in SSMS
If time
Using parameters- Package and project parameters
- Using parameters in expressions
- Deploying parameters
- Why to avoid environments
SQL Server Integrations Services - SSIS (online)