Overview of DTS Package

By: Emil Chang | Views: 1175 | Date: 19-Jul-2011

By using DTS tools to graphically build DTS packages or by programming a package with the DTS object model, you can create custom data movement solutions tailored to the specialized business needs of your organization.

DTS Introduction

Many organizations need to centralize data to improve corporate decision-making. However, their data may be stored in a variety of formats and in different locations. Data Transformation Services (DTS) addresses this vital business need by providing a set of tools that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations supported by DTS connectivity. By using DTS tools to graphically build DTS packages or by programming a package with the DTS object model, you can create custom data movement solutions tailored to the specialized business needs of your organization.

DTS Basics

Data Transformation Services (DTS) provides a set of tools that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations. You create a DTS solution as one or more packages. Each package may contain an organized set of tasks that define work to be performed, transformations on data and objects, workflow constraints that define task execution, and connections to data sources and destinations. DTS packages also provide services, such as logging package execution details, controlling transactions, and handling global variables.

DTS supplies a number of tasks that are part of the DTS object model that can be accessed graphically, through DTS Designer, or programmatically. These tasks, which can be configured individually, cover a wide variety of data copying, data transformation, and notification situations. For example:

Importing and exporting data

DTS can import data from a text file or an OLE DB data source (for example, a Microsoft Access 2000 database) into SQL Server. Alternatively, data can be exported from SQL Server to an OLE DB data destination (for example, a Microsoft Excel 2000 spreadsheet). DTS also allows high-speed data loading from text files into SQL Server tables.
Transforming data
DTS Designer includes a Transform Data task that allows you to select data from a data source connection, map the columns of data to a set of transformations, and send the transformed data to a destination connection. DTS Designer also includes a Data Driven Query task that allows you to map data to parameterized queries.

Copying database objects

With DTS, you can transfer indexes, views, logins, stored procedures, triggers, rules, defaults, constraints, and user-defined data types in addition to the data. In addition, you can generate the scripts to copy the database objects.

Sending and receiving messages to and from other users and packages


DTS includes a Send Mail task that allows you to send an e-mail if a package step succeeds or fails. DTS also includes an Execute Package task that allows one package to run another as a package step, and a Message Queue task that allows you to use Message

Queuing to send and receive messages between packages.

Executing a set of Transact-SQL statements or Microsoft ActiveX scripts against a data source
The Execute SQL and ActiveX Script tasks allow you to write your own SQL statements and scripting code and execute them as a step in a package workflow.
Previous Page Next Page

People Searching On This Page:
  • content
  • ONE OR MORE EMAIL TASK IN DTS PACKAGE
  • how to generate excel sheet in sql 2000 activex DTS package
  • programming DTS object
  • HOW TO set excel file as destination in dts

Related Pages


Skoda Rapid Overview

Skoda Rapid Overview

Articles | Automotive | Cars
Date:
20-Nov-2011  Views: 4919

Skoda India has launched the much-awaited C+ segment sedan ‘Rapid’, which will be manufactured in the same plant (Chakan, Pune) where Vento is also ma ...
Overview of SQL Server Database Triggers

Overview of SQL Server Database Triggers

Articles | Programming | MS SQL
Date:
10-Aug-2011  Views: 1304

A database trigger is a stored procedure that is invoked automatically when a predefined event occurs. ...
DTS vs SSIS - Data Transformation Services vs SQL Server Integration Services

DTS vs SSIS - Data Transformation Services vs SQL Server Integration Services

Articles | Programming | MS SQL
Date:
19-Jul-2011  Views: 2158

Here we have provided some differences between DTS and SSIS. It may be useful to answer interview question related to SSIS (MSBI) ...
What Is Passivation of Stainless Steel –An Overview

What Is Passivation of Stainless Steel –An Overview

Articles | Business
Date:
13-Jul-2011  Views: 1477

The passivation of stainless steel is done to enhance its corrosion resistance properties. The passivation treatment helps to perk up the surface stat ...
Obama Loan Modification and Mortgage Refinancing Plans Overview

Obama Loan Modification and Mortgage Refinancing Plans Overview

Articles | Finance | Loans
Date:
17-Jan-2011  Views: 925

When applying under Making Home Affordable Plan (MHA), it has become essential for home owners to show their financial hardship condition by providing ...
Post Your Comments (No Login Require)
Name : (required)
Email : (required)
Website :

Comment : (required)

59  + 2 =     
Comments
People Searched About:
Content   |   ONE OR MORE EMAIL TASK IN DTS PACKAGE   |   How To Generate Excel Sheet In Sql 2000 Activex DTS Package   |   Programming DTS Object   |   HOW TO Set Excel File As Destination In Dts   |  
Google : 277 times | Yahoo : 83 times | Bing : 221 times |