This video is 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)

Video: Transform Data Task - An Overview of the Screens/Tabs

  • ·Skill level: 100 (Beginner)
  • ·Run Time: 10:23
  • ·Instructor: Scott Whigham

Description:

Do you want to learn DTS? Then watch this video! It's very important that you know the Transform Data Task backwards and forwards!

Download and watch this video

NOTE: You will need the TSCC codec installed to view video

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)

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

NOTE: This video is part of our SQL Server 2000 DTS course.
This video is from Chapter 2: Working with the Common Tasks in DTS

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.