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.
Overview
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
