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
what is an index? : Sql server database administration
What is the report builder?
Name some of the open source software that you can use in alternative to SSR?
Which sql server table is used to hold the stored procedure scripts?
What is difference between oltp and olap?
What is snapshot replication?
What is dynamic cursor in SQL SERVER?
how to control the amount of free space in your index pages? : Sql server database administration
What are magic tables in sql server?
What is sql view?
What is dirty page?
What is the difference between NOROW and LOCKROW?
what are the types of indexes? : Sql server database administration
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
How do we synchronize On-Premise SQL server with SQL Azure?