Interested to Buy Any Domain ? << Click Here >> for more details...
what is Data Transformation Services (DTS) ?can u explain
me in detail?
- 5 Answers
- 14508 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 to convert character strings into numeric values?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How do I create a stored procedure in sql server?
What are the different types of data sources in ssrs?
How to bind a view to the schema of the underlying tables?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What is set nocount on?
What is the default port for SQL Server over a firewall?
How to create a new table in a given schema?
When would you prefer to have a minimum number of indexes?
How to drop an existing user defined function in ms sql server?
What do you mean by a dependent functionality in a build?
Explain what is lock escalation?
Is the primary key column of a table an index in ms sql server?
