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   SiteMap shows list of All Categories in this site.
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 
How to work on DTS?what is the main requirement?
 Question Submitted By :: Nambu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to work on DTS?what is the main requirement?
Answer
# 1		 
DTS (Data Transformation Services) allows you to get stuff 
in and out of SQL Server and between any ODBC and OLE DB 
data source.  That includes DB2, Access, Excel and Text, as 
well as Oracle, MySQL, PostgresSQL and even SQLLite. -in 
fact, anything with an ODBC driver. Not only does it do the 
transfer but it allows you to fill in missing data, do 
column mappings and so on. In other words, you can fiddle 
with the data as it passes through.
 
Is This Answer Correct ?    1 Yes 0 No
Naresh
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
When do we use the UPDATE_STATISTICS command?  3
Which system table contains information on constraints on all the tables created?  2
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds5
select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.  7
What is a view?  4
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person  7
What are defaults? Is there a column to which a default can't be bound?  2
what is difference between nchar and char in Sql server ?  2
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?  3
wht is normalization?can u explain me in detail? TCS6
How can I know what query is executing by by a particural user? (using sp id or any othe way.)  2
How to Run a Query on a Remote SQL Server?  2
What is Transaction?  2
When do you create cluster and noncluster index? Satyam4
What is Report Server,Report Manager and Report Builder in SSRS 2005?  1
What are the advantages of using sql server over ms access or why should one use sql instead of ms access Impetus1
could u plz explain about joins and views?  2
any one can explain Self mapping Delegation Remote Credentials  1
Whether the updations made to the views reflect the original records in the table NIIT5
 
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