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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

About DTS usage ?

Question Posted / shaheen

Answers were Sorted based on User's Feedback



About DTS usage ?..

Answer / s. elaiyaraja

DTS Used for various data transformations.

Not only between databases, its also used to transfers
data's between office excel,CSV, text files, MDB also.
Extracting data's from databases to Excel, mdb, csv, text
files.

We can extract the data's using Queries also(if its from
database).

Is This Answer Correct ?    2 Yes 0 No

About DTS usage ?..

Answer / kinthada cnu

hi all

DTS : Data Transformation service.using DTS object transfor
the data from one database into anothert database.

ex:sqlserver to orcale or ms-acces.....

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

What is difference between foreign key and unique key?

0 Answers  

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

what are user defined datatypes? : Sql server database administration

0 Answers  

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

Is sql server a database?

0 Answers  

Can XML be used to access data?

2 Answers  

How to provide default values to stored procedure parameters?

0 Answers  

what is trigger . hw will it use them

2 Answers   TCS,

how you can get the list of largest tables in a database? : Sql server administration

0 Answers  

What are the disadvantages of using the stored procedures?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories