Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
   
SQL Server Integration Services Training Videos
Integration Services Videos in Series Home  Subscriber Videos  

Script Component as a Source, Transformation and Destination (Video Series)

Video Image 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:



Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/19/2008 1:14:49 PM