Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is format parameter in ssrs?

150


What is filestream?

1049


What are the different types of normalization?

1221


What is dbcc?

1179


What is the difference between a local and a global temporary table?

1174


what is a mixed extent? : Sql server administration

1175


What is the Disadvantage of indexed sequential file.

1130


What are the types of stored procedures in an sql server?

1036


What are the different types of replication are there in sql server 2000?

1087


What happens on checkpoint?

1069


What is an indexing strategy?

1069


Detail about query optimizer?

1158


Can you explain important index characteristics?

1031


How can I create a new template for import ? : sql server management studio

1113


How to create a store procedure with encryption?

1055