what is Data Transformation Services (DTS) ?can u explain
me in detail?

Answers were Sorted based on User's Feedback



what is Data Transformation Services (DTS) ?can u explain me in detail?..

Answer / virendra

It is builtin facility of Sql Server provovided by
microsoft for import and export
database/table/structure/database objects from one database
package/ server to other/differnet.

Is This Answer Correct ?    6 Yes 0 No

what is Data Transformation Services (DTS) ?can u explain me in detail?..

Answer / srikanth

DTS are a kind of routines for transforming data from one
type to other type. suppose we have data in excel sheets or
flat files, comma separated values. DTS helps us in
transforming this type of data to other types like
transofroming to SQL Server tables.
Integration services is the latest technology in this field.
It has got many controls which make the tasks of DTS easier.
so complex transformations can be doen using it. It comes
with SQL Server 2005 Business Intelligence suite

Is This Answer Correct ?    5 Yes 1 No

what is Data Transformation Services (DTS) ?can u explain me in detail?..

Answer / guest

Moving large data from one location to another easily

Is This Answer Correct ?    3 Yes 0 No

what is Data Transformation Services (DTS) ?can u explain me in detail?..

Answer / namz

DTS (Data Transformation Services) comes under Integration
Service.DTS Import and export wizard lets us to import and
export from external data source
DTS has two major components:
1.DTP Data Transformation Pipeline
2.DTR Data Transformation Runtime

Is This Answer Correct ?    3 Yes 2 No

what is Data Transformation Services (DTS) ?can u explain me in detail?..

Answer / lakshmi

DTS is a kind of etl tool which extracts data from wide
range of sources like flatfiles,sql server,excel,oracle etc
and manipulating the data according to business logic by
using transformations before being loading into various
destinations.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What is data integrity? Explain constraints?

1 Answers   Thinksoft,


What is change data capture (cdc) in sql server 2008?

0 Answers  


What are indexers?

0 Answers  


What do you understand by a stored procedure?

0 Answers  


How do you rebuild an identity column?

0 Answers  






what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  


How can delete duplicate records in cte in sql server?

0 Answers  


How and why use sql server?

0 Answers  


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  


sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  


What is the difference between primary key and unique constraints?

0 Answers  


How to use group functions in the select clause in ms sql server?

0 Answers  


Categories