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!

Browse this course's videos now
  • Search for videos within this course

This course is featured in the following packages:


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.
  • Are there any sample videos from this course? Yes! Click here to view this course's free 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.
  • What is included with this course? Our training courses come complete with the video files, PDFs of the course presentation (for lecture-based videos), and sample projects and files where appropriate. Most courses are a blend of demo and lecture but, depending on the topic, some courses are lecture-only while others are demo-only. Read more
  • Do you have something I can email to my boss? Yes, many customers ask for PDF copies of the material covered so that they can get reimbursed by their company for the cost of the course. Download a PDF of the videos in this course
  • 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

Table of Contents

This video training course is separated into chapters. 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-2009 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.