what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 12765 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of the mirroring?
What is system stored procedures?
Can sql servers linked to other servers?
List out the different types of locks available in sql server?
How do you handle datasets larger than 50 gb?
What is ssrs?
Why use “nolock” in sql server?
What is the difference between grant and with grant while giving permissions to the user?
what are the important architecture components of SSRS?
What is the need for indexing?
Please differentiate between a local and a global temporary table?
Define right outer join?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
which backup strategy you are following at ur company
What is the use of partition by in sql server?
