Advanced Scripting Using SSIS Script Tasks and Components
summary
Shows concrete scripts and working demos: an ordered file list using System.IO and LINQ that feeds a ForEach, a script component that caches instance fields to produce correct running totals, and a dictionary-driven dynamic business rules via ADO.NET that routes rows to valid/invalid outputs with error messages. Notes that debugging script components is slow, recommends pre-execute caching, synchronous vs asynchronous outputs, and that all demos run successfully in the session.
AI-written summary · about
chapters (16)
- 0:00Intro
- 0:59Technical Assistance
- 3:52Explore Everything PASS Has to offer
- 4:43John Welch Bio
- 6:04About Me
- 7:19Script Tasks
- 8:25Ordered File List
- 18:11Script Components
- 19:17Running Totals
- 29:20Dynamic Business Rules
- 44:16Tips and Tricks
- 47:10Performance
- 48:30Keeping it DRY
- 48:49Remember...
- 49:24Resources
- 53:47Like What You've Heard?
related talks
47mThe Human Side of PowerShell Scripting
01h 12mAzure DevOps and the SSIS Development Lifecycle
41mScript Blocks Decoded
01h 45mWriting Award Winning PowerShell Functions and Script Modules
35mImproving Your Attributes
22mScript Kit: The Ultimate Open Source Dev Kit
53mScripting and Automation: This Manual Task Could Have Been a Script
43mScripting Big Changes With Small Risk