DTS: Data Transformation Services in SQL Server 2000
DTS is a collection of tools delivered by Microsoft Corporation with SQL Server 2000 for importing, exporting and transforming heterogeneous data between one or more data source such as SQL Sever 2000, MS Excel and MS Access.
OLE DB, an open standard for data access is used for Connectivity. OLE DB Provider for ODBC used for ODBC (Open Database Connectivity).
We need to create one or more packages to perform our action. To create the package, we can use DTS designer, a graphically tool to design a package.
From the Connection, Task and Work flow tools menus by using the drag and drop facility, we can design, edit and save a package.
Menus :
Connection Menu - List of possible connections are available in this menu.
Task Menu - A DTS package consist of one or more tasks. The list of
tasks are available in this menu.
Work Flow Menu – To order the tasks, we need to use work flow items.
There are four ways to saving the DTS Package :
1) Microsoft SQL Server
2) SQL Server 2000 Meta Data Services
3) Structured storage file
4) Microsoft Visual Basic
How to create a DTS Package in SQL SERVER 2000:
Follow the below steps to create the DTS Package
1) Open SQL Server Enterprise Manager
2) In Object Explore, select the Data Transformation Services
3) Right click on the menu, select New Package Menu
4) Using the work area, design an new package using the menu items
|
No responses found. Be the first to respond and make money from revenue sharing program.
|