Friday, June 29, 2007

New SQL Server Integration Services Video Tutorial: Pt. 1 - An Intro to Using the Script Component In a Transformation

Pt. 1 - An Intro to Using the Script Component In a Transformation - view details
The Script Component is a wonderful addition to SSIS and allows you to do transforms, source and destination components all in .NET - you can't get much more flexible that that! This video helps you understand what the Script Component is and shows you how to begin using the Script Component in a Data Flow Task transformation. 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 and who are used to using ActiveX/Active X Script transformations in their Transform Data Tasks) often struggle trying to figure out the best approach to solving a problem with the Script Component!

Highlights from this video:
  • Using the Script Component in your SSIS packages
  • What can you do with a Script Component?
  • When should I use the Script Component?
  • How do I use the Script component in a transformation?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Transform data Task

posted by Scott Whigham @ 4:35 AM