Enable Technology

Database 

Microsoft SQL Server 2012 -2014 Integration Services SSIS




Course Overview


This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.

Duration: 2 day course



Course Content


SQL Server Integration Services Architecture
Version Changes of SSIS From 2008-2012
The SQL Server Integration Service
Understanding Packages
Managing with Control Flow
Moving Data with Data Flow
Understanding Variables
Understanding Parameters

SQL Server Integration Services Tools
Utilizing the Import/Export Wizard
Working in the Explore Window
Creating SQL Server Integration Services Packages
Utilizing Connection Managers

SQL Server Integration Services Tasks
Coding the Script Task
Looping and Sequence Tasks
Utilizing Data Preparation Tasks
Data Loading with the Analysis Services Tasks
Using the Workflow Tasks
Managing SQL with the SQL Tasks
Administration of SQL Using the SQL Management Objects Tasks

Data Flow
Optimizing Sources for Extraction
Using Destinations and Understanding choices
Examining the Transformation and Other Tasks

Variables, Parameters and Expressions
Creating Dynamic Packages
Utilizing SQL Server Integration Services Data Typing
Define and Use Variables and Parameters
Using Expressions in Packages

Containers
Overview of Containers
Utilizing Sequences in a Container
Utilizing Container Loops

Performing Joins
Performing Joins with the Lookup Transformation
Performing Joins with the Merge Transformation
Utilizing Cache Modes in Joins

Tuning SQL Server Integration Services Packages
Examining the SSIS Engine
Using the Best Practices

Debugging SQL Server Integration Services Packages
Designing to Troubleshoot: Using Precedence Constraints
Working with Advanced Logging and Reporting
Handling Errors

Common SQL Server Integration Services Design Patterns
Choosing the Script Task or Script Component
Working with XML
Using Package Hierarchies: Parent Child
Understanding Deployment Strategies 






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;