what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 12753 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
What are the advantages of using stored procedures in sql server?
How to create function with parameter in sql server?
What is truncate table?
What is the difference between rank and dense_rank?
What is a Join and explain its types?
What are trace flags and mention a few common trace flags used with sql server?
What is primary key index?
Explain acid?
Explain insert into select statement?
What the difference between UNION and UNIONALL?
How to find the version of sql server? : sql server database administration
What is ms sql server reporting services?
Can you move the resources after pausing the node? : sql server database administration
Why should you use or avoid select * statements?
Which is the main third-party tool used in sql server?
