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

Which is the latest version of sql server and when it is released?

0 Answers  

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

When do you think a developer should use sql server-based cursors?

0 Answers  

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

How to Debug a Stored Procedure?

5 Answers   Allianz,

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

What number sorts of privileges are accessible in sql?

0 Answers  

syntex of insert

7 Answers  

How to tune a stored procedure?

6 Answers  

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

What are the properties of the transaction?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories