Customer Service



   Frequently Asked Questions

....Domain Search:
  Website Hosting
  Co-location Services
Virus & Spam Control
Ecommerce Software
Other Software
  ITS Group Information Technology



Related Links

 Official Site

Email page
to a friend




Domain Registration

Virus & Spam Control

E-commerce Software

Why Co-locate? 

User Rating: (5/5)

 Read Testimonials

Website Hosting

Using MS SQL 2000 DTS to Export Data

Go Back

Customers with Microsoft SQL 2000 Enterprise Manager installed on their computer have a powerful way to interface with the SQL Server. The DTS (Data Transformation Service) also allows you to import and export to any data type. This example should serve as a starting point on how to move a database from one SQL server to another. You might want to tweak the options to better suit your situation.

To connect to you database and start working on it, you will need:

a. SQL Server IP Address
b. SQL Server Login ID and Password
c. SQL Server database Name

Step 1.
Open Enterprise Manager. Select menu choice, Start -> Program Files -> Microsoft SQL Server -> Enterprise Manager

Step 2.
After Enterprise Manager starts up, and Click on "SQL Server Group". Right click on Database, select "All Tasks > Export Data"

Step 3.
The DTS Wizard will start. Click on "next"

Step 4.
a. Enter the IP address of the source SQL Server
b. Select "Use SQL Server Authentication
c. Enter User Name and Password
d. Select the Source Database
e. Click on "Next >"


Go Back  If you have any questions: or Phone 1-780-701-7282.



Copyright 1999-2008 ITS Group Information Technology. 1-780-701-7282