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 the sql case statement used for?
What are indexes in sql?
What are pages and extents? : SQL Server Architecture
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How to see existing views in ms sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
what's the information that can be stored inside a bit column? : Sql server database administration
What are the transaction properties?
What are the drawbacks of reporting in ssrs?
What are unicode character string data types in ms sql server?
Explain an incremental backup?
What is difference between order by and group by?
What is the purpose of the master database?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is a transactions?