Transferring and Transforming Data in SQL Server 2000

Overview/Description
To enable students to extract and transform data in SQL Server 2000

Target Audience
Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year’s experience administering SQL Server; at least one year’s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
85 Minutes

Objectives:

Transferring and Transforming Data in SQL Server 2000

  • describe the methods available in SQL Server 2000 for transforming and transferring data.
  • use DTS tools to transfer and transform data.
  • create a linked server using Enterprise Manager or T-SQL.
  • create a DTS package in a SQL Server 2000 Server.
  • develop and manage Data Transformation Services (DTS) packages.
  • use the SQL Server 2000 BCP utility and the BULK INSERT command.
  • transfer data to a SQL Server 2000 server using the BCP command line utility and the BULK INSERT statement.


    • Course Number: 31496_eng