what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 12815 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to get a list of columns in a view using the "sp_help" stored procedure?
What are acid properties of transaction?
How do you start single user mode in clustered installations?
How to transfer data from a cursor to variables with a "fetch" statement?
How to rename an existing column with sql server management studio?
How do you create an execution plan?
What is the use of keyword with encryption.
what is the main function of a query parameter?
What are Row versions of DataRow?
What is the process of normalization?
Explain data warehousing in sql server?
What is sql server profiler?
What is mapping schema?
Can we install sql server 2016 on windows 7?
How to add additional conditions in SQL?
