Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server Training Videos · SSIS Video Tutorials
   
DTS Training Videos
SQL Server DTS Videos in Series Home  Subscriber Videos  

Performance Tuning Your Active X Script Transformations With the Multiphase Data Pump (Video Series)

Video Image Video Category: Working with the Common Tasks in DTS

Skill Level: 400 (Intermediate - Advanced)

Versions/Editions Covered: SQL Server 2000
The Multiphase Data Pump (MPDP for short) is hidden from site inside of DTS and, unless you've worked with DTS for quite a while, you may not even realize that it's there. It can seriously boost your ActiveX Script Transformations though and, unless you know how to use it, your DTS packages could take 20 minutes instead of 20 seconds!

Videos in this Series:


Miscellaneous Bits & Pieces:
SQL Server 2000 Resource Kit - More Helpful Tools: "Database Hammer" is a customizable tool for testing your database server with various loads
Keyboard Shortcut for Query Analyzer: CTRL+SHIFT+C comments out the highlighted text while CTRL+SHIFT+R removes comments
Helpful Tools for your SQL Server: If you need to move an Oracle instance into your SQL Server, check out Microsoft's "SQL Server Migration Assistant for Oracle"

Other Websites We Offer
LearnSharePoint.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!
 
8/21/2008 2:11:23 PM