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

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

What is primary key, unique key, and foreign key?

0 Answers  

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

What is SQL Profiler and the use of it?

2 Answers   247Customer,

What authentication modes does sql server support?

0 Answers  

Which data type columns are the best candidates for full-text indexing?

0 Answers  

What are SQL Jobs, please mention the use of it and how to create them.

1 Answers   247Customer,

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

What is difference between clustered index and non clustered index?

0 Answers  

What extended events?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories