Purchase this course now
  • Purchasing this course allows you access to view and download the videos
  • More product info
  • Looking for multi-user licensing info?
$99.95
Add to Cart

Currency conversions:

SQL Server 2000 DTS

  • ·Skill level: 200-500
  • ·Run Time: 8+ hours (46 videos)
  • ·CourseId: 149


This course offers complete coverage of SQL Server 2000's DTS. Whether you are a complete beginner to DTS or an experienced DBA looking to sharpen your data transformation skills, this course can help. Also included are overviews of migrating to SQL Server 2005/2008 Integration Services!

  • Search for videos within this course

Table of Contents

Download a PDF of the videos in this course Download PDF video listing


  • What format is this course in? This course is a video training course in standard .AVI format. After purchasing this course, you will be able to immediately download the entire course (all chapters and all exercises/files).
  • How does it work? It's simple: a user purchases the course and then downloads the course to their hard drive. You can download entire chapters at a time or individual videos. You can then watch the videos from anywhere!
  • If I buy the course, what is included? You get every video in this course along with all of the video exercises/hands-on labs, PDFs, script files and other "bits" that the course may contain. Most courses are a blend of demo and lecture (similar to a live classroom course) but, depending on the topic, some courses are lecture-only while others are demo-only.
  • Are there any free/sample videos from this course? Yes! Check out our free SQL Server 2000 DTS videos
  • If I buy the course, do the videos ever expire? No, the videos do not ever expire. Once you download the videos, you have them for as long as you want! You can read more about this and other questions about purchasing our courses in our pre-sales questions FAQs.
  • Do I have to have an internet connection to watch the videos? No, the videos do not require an internet connection. You will, however, need an internet connection to download the videos!
  • Can I get a certificate saying I passed/took the course? Yes. Once you have downloaded all of the videos in the course, send us a request for a certificate through our contact us page. We'll send you a certificate that looks like this sample certificate.
  • Will this course help me pass a certification exam? Absolutely. We have a lot of members who have successfully earned Microsoft certifications with the help of our training materials. We do not, however, consider ourselves a "certification training company"; we are a "real world training company" and we think there is an important difference between the two. Read more

Scott Whigham

Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott's full bio can be found here)
This course is designed to offer coverage for beginners as well as advanced users. No prior knowledge of DTS is required but prior working experience with SQL Server 7.0 or SQL Server 2000 is necessary to get the most out of this course.
While a true beginner could take this course, it is actually recommended that you have at least 30 days experience working with SQL Server (or equivalent work experience with another database system) prior to taking this course.

Browse this course's videos now

Table of Contents (with descriptions/times)

This SQL Server 2000 DTS video training course is separated into chapters. You may view the videos in each chapter separately by clicking the links below or, if you'd like to view every video on a single page, you want The Big List.

Chapter 1 - Introduction to Data Transformation Services

Abstract: Data Transformation Services in SQL Server 2000 not only changed the way that many businesses moved data around the office, it actually created new companies who existed/started just by migrating data from Source to Destination. DTS is now so common that it has become, like SQL Server itself, a fundamental component in today's offices. This chapter helps you understand the basics of DTS, it's place in the workplace, and why DTS is so great.
Number of Videos: 7
Total Run Time: 1 hour and 10 minutes

Chapter 2 - Working with the Common Tasks in DTS

Abstract: A quick tour of all the basic functionality and tasks of DTS - an excellent beginner-intermediate chapter to help you come to grips with Data Transformation Services.
Number of Videos: 21
Total Run Time: 4 hours and 12 minutes

Chapter 3 - Creating Dynamic DTS Packages with Global Variables and Dynamic Properties

Abstract: Global Variables are the greatest thing in DTS since... well, the Transform Data Task! Global Variables and the Dynamic Properties Task are just so pervasive today that it's hard to imagine designing robust, dynamic packages without them. This chapter helps you understand how to make and manage your own dynamic DTS packages and tasks.
Number of Videos: 3
Total Run Time: 26 minutes

Chapter 4 - Security, Package Architecture, Error Handling and Logging in DTS

Abstract: A large chapter, no doubt, but certainly one that you'll want to familiarize yourself with. This chapter features videos spanning lots of different skill levels and will help you increase your skill level accordingly.
Number of Videos: 5
Total Run Time: 1 hour and 3 minutes

Chapter 5 - Saving, Opening, and Managing DTS Packages

Abstract: There are many choices when saving DTS packages - should you choose SQL Server or Structured Storage File (and what is Meta Data Services)? This chapter is focused on just these questions! How do you copy a DTS package? Can you copy a package from one server to another? What about copying all packages from one server to another?
Number of Videos: 2
Total Run Time: 21 minutes

Chapter 6 - Migrating DTS Packages to SQL Server 2005 Integration Services (SSIS)

Abstract: As you move forward into SQL Server 2005 you'll quickly learn that DTS packages are no longer DTS packages; they're SSIS packages - and what a change there is from DTS to SSIS! This chapter is about the basics of migrating from DTS to SSIS and features an in-place upgrade from SQL Server 2000 to SQL Server 2005.
Number of Videos: 8
Total Run Time: 1 hour and 32 minutes

Browse this course's videos now

^ Back to top

© Copyright 2004-2012 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.