what is Data Transformation Services (DTS) ?can u explain
me in detail?
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
What is format parameter in ssrs?
What is filestream?
What are the different types of normalization?
What is dbcc?
What is the difference between a local and a global temporary table?
what is a mixed extent? : Sql server administration
What is the Disadvantage of indexed sequential file.
What are the types of stored procedures in an sql server?
What are the different types of replication are there in sql server 2000?
What happens on checkpoint?
What is an indexing strategy?
Detail about query optimizer?
Can you explain important index characteristics?
How can I create a new template for import ? : sql server management studio
How to create a store procedure with encryption?