ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
About DTS usage ?
 Question Submitted By :: Shaheen
I also faced this Question!!     Rank Answer Posted By  
 
  Re: About DTS usage ?
Answer
# 1		 
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 ?    0 Yes 0 No
Kinthada Cnu
 
  Re: About DTS usage ?
Answer
# 2		 
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 ?    1 Yes 0 No
S. Elaiyaraja
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How can I create a plain-text flat file from SQL Server as input to another application?  2
What is de-normalization and when do you do it?  3
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no. iFlex2
What is BCP? When do we use it?  1
What is a Lock and let me know Different types of locks?  1
Wht is the difference between stored procedure and trigger TCS4
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
what is the difference between sql query and google query? TCS7
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
What are Magic Table? Evalueserve15
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance  1
In which year relase the 7.0& 2000 & 2005?  1
Which stored procedure will you be running to add a linked server?  1
Difference between server.transfer and server.execute method?  1
How to tune a stored procedure?  5
What is ACID Property of Transaction?  4
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
What is indexed views? plz explain with example?  1
how can we use a composite key for two tables and how can we represent it BoA1
What is normalization and its forms? Challenger-Financial3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com