This chapter comes from our "SQL Server 2000 DTS" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 2: Working with the Common Tasks in DTS

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.

Videos in Chapter 2

1Transform Data Task - An Overview of the Screens/Tabs Download
2Excel as a Data Source - How to Import Excel Spreadsheets and Workbooks Using the Import/Export Wizard Download
3Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS Download
4Part 1 - An Overview of the Send Mail Task and How it Works in DTS Download
5Part 2 - Configure SQL Server to Use the Send Mail Task and Correctly Execute Scheduled Packages Download
6Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task Download
7Part 2 - Import Text File Data into SQL Server Table Using the Transform Data Task Download
8Part 1 - A Basic Walkthrough of the Built-In Tasks Download
9Part 2 - A Basic Walkthrough of the Built-In Tasks Download
10Pt. 1 - An Introduction to the FTP Task (the File Transfer Protocol Task) and How to Download Files Download
11Pt. 2 - Using the FTP Task in Your DTS Packages Download
12Pt. 3 - Working with Variables as File Names and Assigning File Names at Runtime Download
13Pt. 4 - Assigning File Names at Runtime Using VBScript and the ActiveX Scripting Task Download
14Pt. 5 - Working With Multiple Files and Using a Table to Store Processing Info Download
15Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000 Download
16Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000 Download
17Pt. 3 - Using Integration Services (SSIS) to Migrate Tables from Access to SQL Server 2005 Download
18Pt. 1 - An Introduction to Using the Multiphase Datapump Download
19Pt. 2 - An Introduction to Using the Multiphase Datapump Download
20Pt. 3 - Data Transformation Tasks and Advanced Techniques Using the Multiphase Datapump Download
21Pt. 4 - Performance Tuning Your ActiveX Script Transformations Using the MPDP Download

Browse this course's videos now

© 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.