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
What is an execution plan? How would you view the execution plan?
How to make conditional sum in ssrs?
When you use @@error and try-catch?
How do I get to sql server configuration manager?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
what are the new features introduced in sql server 2000? : Sql server database administration
What is the default fill factor value?
How to download and install the scaled-down database adventureworkslt?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Explain sql delete command?
Why the trigger fires multiple times in single login?
Does hive support indexing?
Explain what is raid and what are different types of raid levels?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is difference between index and primary key?