SEARCH:
Quick Search Results

Searching...

VIEW ALL FEATURED ARTICLES | VIEW ALL TOPICS | VIEW ALL REGIONS

A Quick Look at DTS in SQL Server 2000

This article provides an introduction to Data Transformation Services for Microsoft SQL Server 2000. If you have already used DTS in SQL Server 7.0, the first part of this article will be familiar to you.

provided by: 
Originally published at Internet.com

A High-Performance Data Pump - and a Whole Lot More



Data Transformation Services in Microsoft SQL Server 2000 is a high-performance data pump. It is a tool for copying, moving, consolidating, cleansing, and validating data. The data pump loads each row from the data source, manipulates the values in that row, and inserts the row into the data destination.

DTS is also a Rapid Application Development tool for data-oriented programming. It provides a comprehensive set of data manipulation tools organized in a development environment that is both convenient and powerful.

Speed is important when working with data: *

Organizations have to be able to move large amounts of data between different systems within specified processing periods. *

Complex data modifications, including row-by-row processing, are often needed as the data is being moved. If you are manipulating a lot of data, the time required to modify each record must be minimized. *

The design, development, and maintenance of data cleansing applications can be very time-consuming. Tools are needed to speed the development process. ---------------------------------

Note - If you receive a 1GB file of clickstream data at 8:00 a.m. for the previous day's Web site activity, can you load that data into a SQL Server data mart and process the OLAP cubes so that they're ready for a 10:00 a.m. management meeting? ...

Read article at Internet.com site
Related Articles
- Exploring the Oslo Repository
Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.
- Practical Uses for DTS
- Microsoft SQL Server 2000 Error Messages
- What Is a Database Administrator?
- Cross Apply and Outer Apply Operators
- An Overview of Java Database Connectivity
- Replication and Microsoft SQL Server 2000
- Building Microsoft Oslo Models
- Day 1: Learning the Basics of PL/SQL
Regional Articles
- A Quick Look at DTS in SQL Server 2000 Alabama
- A Quick Look at DTS in SQL Server 2000 Alaska
- A Quick Look at DTS in SQL Server 2000 Arizona
- A Quick Look at DTS in SQL Server 2000 Arkansas
- A Quick Look at DTS in SQL Server 2000 California
- A Quick Look at DTS in SQL Server 2000 Colorado
- A Quick Look at DTS in SQL Server 2000 Connecticut
- A Quick Look at DTS in SQL Server 2000 DC
- A Quick Look at DTS in SQL Server 2000 Delaware
- A Quick Look at DTS in SQL Server 2000 Florida
- A Quick Look at DTS in SQL Server 2000 Georgia
- A Quick Look at DTS in SQL Server 2000 Hawaii
- A Quick Look at DTS in SQL Server 2000 Idaho
- A Quick Look at DTS in SQL Server 2000 Illinois
- A Quick Look at DTS in SQL Server 2000 Indiana
- A Quick Look at DTS in SQL Server 2000 Iowa
- A Quick Look at DTS in SQL Server 2000 Kansas
- A Quick Look at DTS in SQL Server 2000 Kentucky
- A Quick Look at DTS in SQL Server 2000 Louisiana
- A Quick Look at DTS in SQL Server 2000 Maine
- A Quick Look at DTS in SQL Server 2000 Maryland
- A Quick Look at DTS in SQL Server 2000 Massachusetts
- A Quick Look at DTS in SQL Server 2000 Michigan
- A Quick Look at DTS in SQL Server 2000 Minnesota
- A Quick Look at DTS in SQL Server 2000 Mississippi
- A Quick Look at DTS in SQL Server 2000 Missouri
- A Quick Look at DTS in SQL Server 2000 Montana
- A Quick Look at DTS in SQL Server 2000 Nebraska
- A Quick Look at DTS in SQL Server 2000 Nevada
- A Quick Look at DTS in SQL Server 2000 New Hampshire
- A Quick Look at DTS in SQL Server 2000 New Jersey
- A Quick Look at DTS in SQL Server 2000 New Mexico
- A Quick Look at DTS in SQL Server 2000 New York
- A Quick Look at DTS in SQL Server 2000 North Carolina
- A Quick Look at DTS in SQL Server 2000 North Dakota
- A Quick Look at DTS in SQL Server 2000 Ohio
- A Quick Look at DTS in SQL Server 2000 Oklahoma
- A Quick Look at DTS in SQL Server 2000 Oregon
- A Quick Look at DTS in SQL Server 2000 Pennsylvania
- A Quick Look at DTS in SQL Server 2000 Rhode Island
- A Quick Look at DTS in SQL Server 2000 South Carolina
- A Quick Look at DTS in SQL Server 2000 South Dakota
- A Quick Look at DTS in SQL Server 2000 Tennessee
- A Quick Look at DTS in SQL Server 2000 Texas
- A Quick Look at DTS in SQL Server 2000 Utah
- A Quick Look at DTS in SQL Server 2000 Vermont
- A Quick Look at DTS in SQL Server 2000 Virginia
- A Quick Look at DTS in SQL Server 2000 Washington
- A Quick Look at DTS in SQL Server 2000 West Virginia
- A Quick Look at DTS in SQL Server 2000 Wisconsin
- A Quick Look at DTS in SQL Server 2000 Wyoming
Related Articles
- Exploring the Oslo Repository
Walk through examples and see how existing Repository models are constructed using the M language, how the models are stored in a SQL database, and how to query the SQL database for model information.
- Practical Uses for DTS
- Microsoft SQL Server 2000 Error Messages
- What Is a Database Administrator?
- Cross Apply and Outer Apply Operators
- An Overview of Java Database Connectivity
- Replication and Microsoft SQL Server 2000
- Building Microsoft Oslo Models
- Day 1: Learning the Basics of PL/SQL
Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin
Topics:
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML