what is Data Transformation Services (DTS) ?can u explain
me in detail?
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
Data table as parameter in sql server?
What is a data source or ds? : sql server analysis services, ssas
When to use Inner join & when to use subquery?
what are the new features in SSRS?
What are character string data types in ms sql server?
When columns are added to existing tables, what do they initially contain?
Give main differences between "Truncate" and "Delete".
What are the aggregate and scalar functions?
Which is faster statement or preparedstatement?
Explain what is the function of sql server agent windows service?
What are acid properties of transaction?
Write SQL queries on Self Join and Inner Join.
How much does sql server 2016 cost?
How to create user messages with print statements in ms sql server?
what is a join and explain different types of joins? : Sql server database administration