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

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

how to rest identity columns in sql server

3 Answers   Matrix,

Can you name some of the dml commands in sql?

0 Answers  

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

Where the sql logs gets stored? : sql server database administration

0 Answers  

explain the type of contraints

3 Answers  

How to remove duplicate rows from table except one?

0 Answers  

What is “asynchronous” communication in sql server service broker?

0 Answers  

What are pessimistic lock and optimistic lock?

0 Answers  

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories