Script Component as a Source, Transformation and Destination - Video Series Video Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z Skill Level: 400 (Intermediate - Advanced) Versions/Editions Covered: SQL Server 2005 The Script Component feature of SSIS is perhaps the most flexible of all the tasks/transformations in SSIS. Drag a Data Flow task onto your SSIS Designer surface and then add a Script Component to your Data Flow container. Notice how it can be either a Source, Destination or Transformation? It is clearly very flexible! But, with all that flexibility comes a price: complexity. Newbies have a particularly tough time understanding when to use the Script Component or another task. Even old-timers (that's folks with lots of DTS experience) often struggle trying to figure out the best approach to solving a problem with the Script Component! This video series, recorded by our resident SSIS trainer Scott Whigham, is a six part series that covers topics like: When should I use the Script Component? How do I use the Script Component as a Data Source? How do I use the Script component in a transformation? Using the Script Component as a destination and much more

Videos in this Series:

Title Skill Length Download Pt. 1 - An Intro to Using the Script Component In a Transformation   400 12 mins. Download Pt. 2 - Using a Script Component in a Data Flow Task Transformation   400 13 mins. Download Pt. 3 - Customizing the Script Component Transformation with VB.NET   400 13 mins. Download Pt. 4 - Using a Script Component as a Source Connection   400 11 mins. Download Pt. 5 - Customizing the Script Component to be a Data Source   500 10 mins. Download Pt. 6 - Finalizing the Script Component as a Source Data Flow and How to Use Scr...   500 8 mins. Download

< Return to list of all videos