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

An In-Depth Case Study of Migrating a DTS Package to SSIS (Video Series)

Video Image Video Category: Migrating and Upgrading From SQL Server 2000 Data Transformation Services (DTS) to SSIS in SQL 2005

Skill Level: 200 (Beginner - Intermediate)

Versions/Editions Covered: SQL Server 2005
This is quite a large video series - seven videos in all - that covers migrating a mildly complex DTS package into SSIS using a variety of techniques. If you want an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. You'll see how to loop through each file returned from a result set, download that file via an FTP Task, and then bulk load that text file's data in a SQL Server table (couched in a "Here's how we did it in DTS and here's how we do it in SSIS").

Highlights from this video series:
  • Using the Package Migration Wizard (PMW)
  • Limitations of the PMW
  • What to Do When the PMW Reports Success But Your SSIS Packages Fail
  • Should You Rewrite Your DTS Package or Use the PMW?
and much more

Videos in this Series:



Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
Become a Guru
 
   
 
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!
 
12/5/2008 2:30:16 AM