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
Define cross join in sql server joins?
define and explain the differences between clustered and non-clustered indexes.
What is the maximum length of an alert name?
What is the difference between drop table and truncate table?
What is the difference between a fill factor of 100 and 0?
Explain the properties of a relational table?
How can you control the amount of free space in your index pages?
Explain what is the function of sql server agent windows service?
What according to you is the difference between mysql and sql server performance?
What do you mean by 'normalization'?
Explain the architecture of ms sql reporting service?
what type of index will get created after executing the above statement? : Sql server database administration
What is the default value of an integer data type in sql server 2005?
How can you list all the table constraints in a database?
What is attribute hierarchy? : sql server analysis services, ssas