what is Data Transformation Services (DTS) ?can u explain
me in detail?
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
How to generate create view script on an existing view?
How to store and query spatial data?
What is tempdb in sql server?
Define union, union all, minus, intersect?
What is the new security features added in sql server 2016? : sql server security
What is difference between stored procedure and user defined function?
List out different types of normalizations in sql server and explain each of them?
What is user defined datatypes and when you should go for them?
What does top operator do?
What are the properties of the transaction?
What is page-level compression?
What sql server means?
When we should use @@error?
How are the unique and primary key constraints different?
Explain throw statement in sql server 2008?