Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Discover advanced scripting techniques for SQL Server Integration Services (SSIS) in this 56-minute conference talk from PASS Data Community Summit. Learn how to leverage Script Tasks and Components to enhance your ETL processes, create ordered file lists, implement running totals, and apply dynamic business rules. Gain valuable insights on performance optimization, maintaining DRY (Don't Repeat Yourself) principles, and best practices for SSIS scripting. Explore practical tips and tricks shared by expert John Welch to elevate your SSIS development skills and streamline your data integration workflows.
Syllabus
Intro
Technical Assistance
Explore Everything PASS Has to offer
John Welch Bio
About Me
Script Tasks
Ordered File List
Script Components
Running Totals
Dynamic Business Rules
Tips and Tricks
Performance
Keeping it DRY
Remember...
Resources
Like What You've Heard?
Taught by
PASS Data Community Summit