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

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

Why use sub query in sql server and list out types of sub queries?

0 Answers  

Which are the new data types introduced in sql server 2008?

0 Answers  

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

What is policy based management (pbm)? : sql server database administration

0 Answers  

What is delete query?

0 Answers  

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

What is the use of partition by in sql server?

0 Answers  

Explain DBCC?

0 Answers   QuestPond,

What is the syntax for encrypting a column in SQL Server?

0 Answers   MindCracker,

What is a trigger?

4 Answers  

Can you name a few encryption mechanisms in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories