How DTS is used to extract, transform and consolidate data

Describe how DTS is used to extract, transform and consolidate data.

Data Transformation Services is a set of tools available in SQL server that helps to extract, transform and consolidate data. This data can be from different sources into a single or multiple destinations depending on DTS connectivity. To perform such operations DTS offers a set of tools. Depending on the business needs, a DTS package is created. This package contains a list of tasks that define the work to be performed on, transformations to be done on the data objects.

Import or Export data: DTS can import data from a text file or an OLE DB data source into a SQL server or vice versa.

Transform data: DTS designer interface also allows 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. For parameterized queries and mapping purposes, Data driven query task can be used from the DTS designer.

Consolidate data: the DTS designer can also be used to transfer indexes, views, logins, triggers and user defined data. Scripts can also be generated for the sane For performing these tasks, a valid connection(s) to its source and destination data and to any additional data sources, such as lookup tables must be established.
What is built-in function? Explain its type i.e. Rowset, Aggregate and scalar
A built in function of sql is used for performing calculations. These are standard functions provided by sql......
What are the benefits of User-Defined Functions?
User defined functions are created and defined by the user. They are created as per users needs.........
Sql server - What is an index?
Indexes help us to find data faster. It can be created on a single column or a combination of columns........
Post your comment