what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 13535 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
last function used in MS Access to convert sql what function will use in sql
What is oltp (online transaction processing)?
How to Check if table exists in sql server?
What are the default system databases in sql server 2000?
Write a sql query to delete duplicate records from a table called table1
What is the difference between NOROW and LOCKROW?
How to update muliple row in single query?
How to return the date part only from a sql server datetime datatype?
What is difference in performance between insert top (n) into table and using top with insert?
Can you explain what is sql server english query?
What is bit data type? What's the information that can be stored inside a bit column?
how can you attach more than 20 ldf files in sql server
What are the general features of sql server management studio? : sql server management studio
What is sql server english query?
what is a mixed extent? : Sql server administration
