Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Building Better SSIS Packages

PASS Data Community Summit via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover essential techniques for creating more robust and efficient SQL Server Integration Services (SSIS) packages in this comprehensive conference talk. Learn how to enhance reliability through improved notification systems, audit trails, and logging practices. Explore resiliency design patterns for both control and data flow. Dive into reusability strategies using incremental loads, and boost maintainability with proper documentation. Gain insights on performance optimization, including effective lookup management and avoiding unnecessary expenses. Address security concerns by understanding package protection levels, securing parameter values, managing runtime security credentials, and safeguarding the SSIS catalog. Elevate your SSIS package development skills and create more dependable, maintainable, and secure data integration solutions.

Syllabus

Intro
Technical Assistance
PASS SUMMIT 2015
Explore Everything PASS Has to offer
About Tim Mitchell
Reliability
Notification
Audit Trail
Logging
Resiliency - Design Patterns
Control Flow
Data Flow
Reusability Through Incremental Loads
Maintainability
Documentation
Performance Considerations
Lookup Management
Avoid unnecessary Expenses
Blocking Transforms
Slow Transformations
Package Protection Level
Securing Parameter Values
Runtime Security Credentials
Securing the SSIS Catalog
Like What You've Heard?

Taught by

PASS Data Community Summit

Reviews

Start your review of Building Better SSIS Packages

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.