SEARCH:
VIEW ALL FEATURED ARTICLES | VIEW ALL TOPICS | VIEW ALL REGIONS

A Quick Look at DTS in SQL Server 2000 Texas

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.

Local Companies

SoloComputers.com
915-204-8163
7903 Pinebrook Dr.
San Antonio, TX
Information Processing Corporation
972-404-9244
13747 Montfort, Suite 300
Dallas, TX
HRsmart
972-740-9421
2929 N.Central Expressway
Richardson, TX
Catalis, Inc.
(512) 874-7664
7801 N. Capital of Texas Hwy
Austin, TX
Parts-People.Com Inc
512-339-1990
3106 Industrial Terrace
Austin, TX
Heatwave Interactive
512-553-0607
P.O. Box 369
Cedar Park, TX
Maxtrus Micro
(800) 910-2380
4781 Snow Dr
Mesquite, TX
MLM Software
+1-402-524-6464
Berkeley House
Bristol, TX
Palindrome Software Labs Ltd
206-366-5542
7700 WillowChase BLVD
Houston, TX
Delta Business Solutions
(281) 445-3600
525 N. Sam Houston PKWY E
Houston, TX

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

Featured Local Company

Heatwave Interactive

512-553-0607
P.O. Box 369
Cedar Park, TX
http://www.heatwaveinteractive.com

Located in Austin, Texas, Heatwave Interactive is an entertainment software company whose mission is to create original, character-based games that unite the power of online gaming with the excitement of traditional video games.
Read more about A Quick Look at DTS in SQL Server 2000

Related Articles
- Microsoft SQL Server 2000 Error Messages Texas
SQL Server alerts you to possible problems with databases, objects, or the server, but how do you in determine and fix the problem. The first step to troubleshooting problems is to understand how to read and where to find SQL Server error messages.
- Exploring the Oslo Repository Texas
- Day 1: Learning the Basics of PL/SQL Texas
- Building Microsoft Oslo Models Texas
- Cross Apply and Outer Apply Operators Texas
- Practical Uses for DTS Texas
- What Is a Database Administrator? Texas
- An Overview of Java Database Connectivity Texas
- Replication and Microsoft SQL Server 2000 Texas
Regional Articles
- A Quick Look at DTS in SQL Server 2000 Abilene TX
- A Quick Look at DTS in SQL Server 2000 Alamo TX
- A Quick Look at DTS in SQL Server 2000 Alice TX
- A Quick Look at DTS in SQL Server 2000 Allen TX
- A Quick Look at DTS in SQL Server 2000 Alvin TX
- A Quick Look at DTS in SQL Server 2000 Amarillo TX
- A Quick Look at DTS in SQL Server 2000 Angleton TX
- A Quick Look at DTS in SQL Server 2000 Arlington TX
- A Quick Look at DTS in SQL Server 2000 Austin TX
- A Quick Look at DTS in SQL Server 2000 Azle TX
- A Quick Look at DTS in SQL Server 2000 Baytown TX
- A Quick Look at DTS in SQL Server 2000 Beaumont TX
- A Quick Look at DTS in SQL Server 2000 Bedford TX
- A Quick Look at DTS in SQL Server 2000 Beeville TX
- A Quick Look at DTS in SQL Server 2000 Bellaire TX
- A Quick Look at DTS in SQL Server 2000 Belton TX
- A Quick Look at DTS in SQL Server 2000 Big Spring TX
- A Quick Look at DTS in SQL Server 2000 Boerne TX
- A Quick Look at DTS in SQL Server 2000 Borger TX
- A Quick Look at DTS in SQL Server 2000 Brenham TX
- A Quick Look at DTS in SQL Server 2000 Brownsville TX
- A Quick Look at DTS in SQL Server 2000 Brownwood TX
- A Quick Look at DTS in SQL Server 2000 Bryan TX
- A Quick Look at DTS in SQL Server 2000 Burleson TX
- A Quick Look at DTS in SQL Server 2000 Canyon TX
- A Quick Look at DTS in SQL Server 2000 Carrollton TX
- A Quick Look at DTS in SQL Server 2000 Cedar Hill TX
- A Quick Look at DTS in SQL Server 2000 Cedar Park TX
- A Quick Look at DTS in SQL Server 2000 Channelview TX
- A Quick Look at DTS in SQL Server 2000 Cleburne TX
- A Quick Look at DTS in SQL Server 2000 Cleveland TX
- A Quick Look at DTS in SQL Server 2000 Clute TX
- A Quick Look at DTS in SQL Server 2000 College Station TX
- A Quick Look at DTS in SQL Server 2000 Colleyville TX
- A Quick Look at DTS in SQL Server 2000 Conroe TX
- A Quick Look at DTS in SQL Server 2000 Converse TX
- A Quick Look at DTS in SQL Server 2000 Coppell TX
- A Quick Look at DTS in SQL Server 2000 Copperas Cove TX
- A Quick Look at DTS in SQL Server 2000 Corpus Christi TX
- A Quick Look at DTS in SQL Server 2000 Corsicana TX
- A Quick Look at DTS in SQL Server 2000 Crosby TX
- A Quick Look at DTS in SQL Server 2000 Cypress TX
- A Quick Look at DTS in SQL Server 2000 Dallas TX
- A Quick Look at DTS in SQL Server 2000 Dayton TX
- A Quick Look at DTS in SQL Server 2000 Deer Park TX
- A Quick Look at DTS in SQL Server 2000 Del Rio TX
- A Quick Look at DTS in SQL Server 2000 Del Valle TX
- A Quick Look at DTS in SQL Server 2000 Denison TX
- A Quick Look at DTS in SQL Server 2000 Denton TX
- A Quick Look at DTS in SQL Server 2000 Desoto TX
- A Quick Look at DTS in SQL Server 2000 Dickinson TX
- A Quick Look at DTS in SQL Server 2000 Donna TX
- A Quick Look at DTS in SQL Server 2000 Dumas TX
- A Quick Look at DTS in SQL Server 2000 Duncanville TX
- A Quick Look at DTS in SQL Server 2000 Eagle Pass TX
- A Quick Look at DTS in SQL Server 2000 Edinburg TX
- A Quick Look at DTS in SQL Server 2000 El Campo TX
- A Quick Look at DTS in SQL Server 2000 El Paso TX
- A Quick Look at DTS in SQL Server 2000 Ennis TX
- A Quick Look at DTS in SQL Server 2000 Euless TX
- A Quick Look at DTS in SQL Server 2000 Floresville TX
- A Quick Look at DTS in SQL Server 2000 Flower Mound TX
- A Quick Look at DTS in SQL Server 2000 Fort Worth TX
- A Quick Look at DTS in SQL Server 2000 Friendswood TX
- A Quick Look at DTS in SQL Server 2000 Frisco TX
- A Quick Look at DTS in SQL Server 2000 Galveston TX
- A Quick Look at DTS in SQL Server 2000 Garland TX
- A Quick Look at DTS in SQL Server 2000 Gatesville TX
- A Quick Look at DTS in SQL Server 2000 Georgetown TX
- A Quick Look at DTS in SQL Server 2000 Gilmer TX
- A Quick Look at DTS in SQL Server 2000 Granbury TX
- A Quick Look at DTS in SQL Server 2000 Grand Prairie TX
- A Quick Look at DTS in SQL Server 2000 Grapevine TX
- A Quick Look at DTS in SQL Server 2000 Greenville TX
- A Quick Look at DTS in SQL Server 2000 Groves TX
- A Quick Look at DTS in SQL Server 2000 Haltom City TX
- A Quick Look at DTS in SQL Server 2000 Harker Heights TX
- A Quick Look at DTS in SQL Server 2000 Harlingen TX
- A Quick Look at DTS in SQL Server 2000 Henderson TX
- A Quick Look at DTS in SQL Server 2000 Houston TX
- A Quick Look at DTS in SQL Server 2000 Humble TX
- A Quick Look at DTS in SQL Server 2000 Huntsville TX
- A Quick Look at DTS in SQL Server 2000 Hurst TX
- A Quick Look at DTS in SQL Server 2000 Irving TX
- A Quick Look at DTS in SQL Server 2000 Jacksonville TX
- A Quick Look at DTS in SQL Server 2000 Joshua TX
- A Quick Look at DTS in SQL Server 2000 Katy TX
- A Quick Look at DTS in SQL Server 2000 Kaufman TX
- A Quick Look at DTS in SQL Server 2000 Keller TX
- A Quick Look at DTS in SQL Server 2000 Kerrville TX
- A Quick Look at DTS in SQL Server 2000 Kilgore TX
- A Quick Look at DTS in SQL Server 2000 Killeen TX
- A Quick Look at DTS in SQL Server 2000 Kingsville TX
- A Quick Look at DTS in SQL Server 2000 Kyle TX
- A Quick Look at DTS in SQL Server 2000 La Porte TX
- A Quick Look at DTS in SQL Server 2000 Lake Jackson TX
- A Quick Look at DTS in SQL Server 2000 Lancaster TX
- A Quick Look at DTS in SQL Server 2000 Laredo TX
- A Quick Look at DTS in SQL Server 2000 League City TX
- A Quick Look at DTS in SQL Server 2000 Leander TX
- A Quick Look at DTS in SQL Server 2000 Levelland TX
- A Quick Look at DTS in SQL Server 2000 Lewisville TX
- A Quick Look at DTS in SQL Server 2000 Livingston TX
- A Quick Look at DTS in SQL Server 2000 Lockhart TX
- A Quick Look at DTS in SQL Server 2000 Longview TX
- A Quick Look at DTS in SQL Server 2000 Lubbock TX
- A Quick Look at DTS in SQL Server 2000 Lufkin TX
- A Quick Look at DTS in SQL Server 2000 Mabank TX
- A Quick Look at DTS in SQL Server 2000 Magnolia TX
- A Quick Look at DTS in SQL Server 2000 Mansfield TX
- A Quick Look at DTS in SQL Server 2000 Marble Falls TX
- A Quick Look at DTS in SQL Server 2000 Marshall TX
- A Quick Look at DTS in SQL Server 2000 Mc Kinney TX
- A Quick Look at DTS in SQL Server 2000 Mcallen TX
- A Quick Look at DTS in SQL Server 2000 Mercedes TX
- A Quick Look at DTS in SQL Server 2000 Mesquite TX
- A Quick Look at DTS in SQL Server 2000 Midland TX
- A Quick Look at DTS in SQL Server 2000 Mineral Wells TX
- A Quick Look at DTS in SQL Server 2000 Mission TX
- A Quick Look at DTS in SQL Server 2000 Missouri City TX
- A Quick Look at DTS in SQL Server 2000 Nacogdoches TX
- A Quick Look at DTS in SQL Server 2000 Navasota TX
- A Quick Look at DTS in SQL Server 2000 Nederland TX
- A Quick Look at DTS in SQL Server 2000 New Braunfels TX
- A Quick Look at DTS in SQL Server 2000 New Caney TX
- A Quick Look at DTS in SQL Server 2000 North Richland Hills TX
- A Quick Look at DTS in SQL Server 2000 Odessa TX
- A Quick Look at DTS in SQL Server 2000 Orange TX
- A Quick Look at DTS in SQL Server 2000 Palestine TX
- A Quick Look at DTS in SQL Server 2000 Pampa TX
- A Quick Look at DTS in SQL Server 2000 Paris TX
- A Quick Look at DTS in SQL Server 2000 Pasadena TX
- A Quick Look at DTS in SQL Server 2000 Pearland TX
- A Quick Look at DTS in SQL Server 2000 Pflugerville TX
- A Quick Look at DTS in SQL Server 2000 Pharr TX
- A Quick Look at DTS in SQL Server 2000 Plainview TX
- A Quick Look at DTS in SQL Server 2000 Plano TX
- A Quick Look at DTS in SQL Server 2000 Port Arthur TX
- A Quick Look at DTS in SQL Server 2000 Port Lavaca TX
- A Quick Look at DTS in SQL Server 2000 Porter TX
- A Quick Look at DTS in SQL Server 2000 Red Oak TX
- A Quick Look at DTS in SQL Server 2000 Richardson TX
- A Quick Look at DTS in SQL Server 2000 Richmond TX
- A Quick Look at DTS in SQL Server 2000 Rio Grande City TX
- A Quick Look at DTS in SQL Server 2000 Robstown TX
- A Quick Look at DTS in SQL Server 2000 Rockport TX
- A Quick Look at DTS in SQL Server 2000 Rockwall TX
- A Quick Look at DTS in SQL Server 2000 Roma TX
- A Quick Look at DTS in SQL Server 2000 Rosenberg TX
- A Quick Look at DTS in SQL Server 2000 Rosharon TX
- A Quick Look at DTS in SQL Server 2000 Round Rock TX
- A Quick Look at DTS in SQL Server 2000 Rowlett TX
- A Quick Look at DTS in SQL Server 2000 San Angelo TX
- A Quick Look at DTS in SQL Server 2000 San Antonio TX
- A Quick Look at DTS in SQL Server 2000 San Benito TX
- A Quick Look at DTS in SQL Server 2000 San Marcos TX
- A Quick Look at DTS in SQL Server 2000 Schertz TX
- A Quick Look at DTS in SQL Server 2000 Seabrook TX
- A Quick Look at DTS in SQL Server 2000 Seagoville TX
- A Quick Look at DTS in SQL Server 2000 Seguin TX
- A Quick Look at DTS in SQL Server 2000 Sherman TX
- A Quick Look at DTS in SQL Server 2000 Silsbee TX
- A Quick Look at DTS in SQL Server 2000 South Houston TX
- A Quick Look at DTS in SQL Server 2000 Southlake TX
- A Quick Look at DTS in SQL Server 2000 Spring TX
- A Quick Look at DTS in SQL Server 2000 Springtown TX
- A Quick Look at DTS in SQL Server 2000 Stephenville TX
- A Quick Look at DTS in SQL Server 2000 Sugar Land TX
- A Quick Look at DTS in SQL Server 2000 Sulphur Springs TX
- A Quick Look at DTS in SQL Server 2000 Temple TX
- A Quick Look at DTS in SQL Server 2000 Terrell TX
- A Quick Look at DTS in SQL Server 2000 Texarkana TX
- A Quick Look at DTS in SQL Server 2000 Texas City TX
- A Quick Look at DTS in SQL Server 2000 The Colony TX
- A Quick Look at DTS in SQL Server 2000 Tomball TX
- A Quick Look at DTS in SQL Server 2000 Tyler TX
- A Quick Look at DTS in SQL Server 2000 Universal City TX
- A Quick Look at DTS in SQL Server 2000 Uvalde TX
- A Quick Look at DTS in SQL Server 2000 Victoria TX
- A Quick Look at DTS in SQL Server 2000 Vidor TX
- A Quick Look at DTS in SQL Server 2000 Waco TX
- A Quick Look at DTS in SQL Server 2000 Waxahachie TX
- A Quick Look at DTS in SQL Server 2000 Weatherford TX
- A Quick Look at DTS in SQL Server 2000 Weslaco TX
- A Quick Look at DTS in SQL Server 2000 Wharton TX
- A Quick Look at DTS in SQL Server 2000 Wichita Falls TX
- A Quick Look at DTS in SQL Server 2000 Willis TX
- A Quick Look at DTS in SQL Server 2000 Woodway TX
- A Quick Look at DTS in SQL Server 2000 Wylie TX
Related Articles
- Exploring the Oslo Repository Texas
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.
- An Overview of Java Database Connectivity Texas
- Cross Apply and Outer Apply Operators Texas
- What Is a Database Administrator? Texas
- Day 1: Learning the Basics of PL/SQL Texas
- Practical Uses for DTS Texas
- Replication and Microsoft SQL Server 2000 Texas
- Microsoft SQL Server 2000 Error Messages Texas
- Building Microsoft Oslo Models Texas
Related Local Events
PBIOS - Permian Basin International Oil Show 2010
Dates: 10/19/2010 - 10/21/2010
Location: Ector County Coliseum Complex
Midland, TX
View Details
Subsea Tieback Exhibition (SSTB)
Dates: 3/2/2010 - 3/4/2010
Location: Moody Gardens Hotel & Convention Center
Galveston, TX
View Details
Renewable Energy World Conference & Expo North America
Dates: 2/23/2010 - 2/25/2010
Location: Austin Convention Center, Austin
Austin, TX
View Details
Deep Offshore Technology (DOT 2010)
Dates: 2/2/2010 - 2/4/2010
Location: George R. Brown Convention Center
Houston, TX
View Details
Computer Measurement Group (CMG)
Dates: 12/6/2009 - 12/11/2009
Location: Gaylord Texan
Dallas, TX
View Details
Topics: 
Architecture & Design Languages & Tools Project Management Web Services
Database Microsoft & .NET Security Wireless
Java Open Source Techniques XML