Interested to Buy Any Domain ? << Click Here >> for more details...
what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 14361 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / srikanth
DTS are a kind of routines for transforming data from one
type to other type. suppose we have data in excel sheets or
flat files, comma separated values. DTS helps us in
transforming this type of data to other types like
transofroming to SQL Server tables.
Integration services is the latest technology in this field.
It has got many controls which make the tasks of DTS easier.
so complex transformations can be doen using it. It comes
with SQL Server 2005 Business Intelligence suite
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do you improve the performance of a SQL Azure Database?
What happens if you delete a table that is used by a view?
Explain what are the different index configurations a table can have?
How to convert a numeric expression from one data type to another?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What protocol does sql server use?
How to update multiple rows with one update statement in ms sql server?
How to connect php with different port numbers?
Explain the difference between delete,drop and truncate in SQL Server?
Define self join?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is the use of nvl work?
What is sql server agent and what are the two modes of authentication in sql server?
How to view existing indexes on an given table using sp_help?
How to find the login name linked to a given user name?
