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 difference between the 2 operating modes of database mirroring?
optimization techinques
What is updatable resultset?
Can you explain about buffer cash and log cache in sql server?
Can we add an identity column to decimal datatype?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to include text values in sql statements?
What will be query used to get the list of triggers in a database?
What is the difference between ddl and dml?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Do you know what are the ways available in sql server to execute sql statements?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to assign null values to variables or columns?