Interested to Buy Any Domain ? << Click Here >> for more details...
what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 14604 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / guest
Moving large data from one location to another easily
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
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 |
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is deploy, process and build? : sql server analysis services, ssas
Can you explain what is sql server english query?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
How do you Implement SSIS Packages in your Project?
how do we find every fifth record in a table
Why are views required in the sql server or in any other database?
How to convert binary strings into integers in ms sql server?
What is temporary stored procedure?
What is unique key constraint?
How to make a column nullable?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
