Data Transformation Services

Project Synopsis

Project Title: Data Transformation Services (custom data movement solutions)

Introduction to application Area

. 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.

Data Transformation Services (DTS) uses the DTS Information Model to persist data transformation meta data in Microsoft SQL Server™ 2000 Meta Data Services. The DTS Information Model is based on the Transformations package of the Open Information Model (OIM).The DTS Information Model describes: The data transformations and how they are grouped into larger execution units. The types of data accessed. Specifically, the DTS Information Model allows: The storage of data transformation Meta data in one well-defined location. Storing this information in Meta Data Services allows existing transformations to be reused when a data warehouse or data mart is being rebuilt. The sharing of data transformation information across multiple tools. This allows the use of tools from different vendors during the building and maintenance of data warehouses.

Modules of the Project

Word to Sql

In this module we can convert word document to sql database. For this first input a word file and press convert function.

Excel to Sql

In this module we can convert excel data to sql database.

For this first input an excel file and press convert function.

Notepad to Sql

In this module we can convert notepad data to sql database.

For this first input a notepad file and press convert function.

Xml To Sql

In this module we can convert xml document to sql database. For this first input an xml file and press convert function.

Sql To to Word

In this module we can convert Sql Data to word.

For this first select an sql table and press convert function.

Sql To Excel

In this module we can convert Sql Data to excel. For this first select an sql table and press convert function.

Sql To NotePad

In this module we can convert Sql Data to notepad. For this first select an sql table and press convert function.

Sql To xml

In this module we can convert Sql Data to xml. For this first select an sql table and press convert function.

sql to oracle

In this module we can convert Sql Data to oracle . For this first select an sql table and press convert function.