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
What is the difference between DTS and SSIS?
 Question Submitted By :: Durga Prasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between DTS and SSIS?
Answer
# 1
DTS--> Data Transformation Services 
SSIS-->Sql Server Integration Services
in DTS:Message Boxes in activeX scripts
SSIS :Message Boxes In Script Tasks 

In DTS:dynamic Properties+ActiveX scripts
SSIS :Configurations+PropertyExpressions

IN
DTS:no deploymentWizard
SSIS:deployment wizards are there 

DTs:Limited Set of Transformations
SSIS:huge number of Transformations are available 
DTS:ni BI Functionality
SSIS:complete BI Functionality
 
Is This Answer Correct ?    9 Yes 5 No
Ramesh
 
  Re: What is the difference between DTS and SSIS?
Answer
# 2
Hi,
The DTS and SSIS are both used in SQL Server
Transformations. Th e DTS was used for transformation
purpose upto SQL Server 2000 and SSIS (Including SSAS and
SSRS) are the advanced to DTS and are included in SQL Server
2005 onwards. The capability of SSIS tool in comparison with
DTS is tremendous. This SSIS tool is in competition with
other ETL Tools in the present.The SSIS has lot added
features as per the current requirements.
 
Is This Answer Correct ?    5 Yes 5 No
Maddy
 
 
 
  Re: What is the difference between DTS and SSIS?
Answer
# 3
Internal architect of SSIS is entirely different than DTS 
and mainly designed to achieve high degree of parallelism 
and to improve performance. In Microsoft Business 
Intelligence, Integration services are coupled with 
Analysis and reporting services. It could process thet data 
for Dimension processing and Partition processing.Using 
Data profiling task you could analyze data before 
processing and find out the percentage of null values. 
Using WMI Data reader task you could get information about 
system hardware, software and also network information.
More important, it has great security features like 
password protection, Digital signature, Encrypt with 
password. Even we could secure it using Operating system 
permission and using SQL server roles.

SSIS is really a great!
 
Is This Answer Correct ?    1 Yes 0 No
Rajesh S. Chandan
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)  1
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query? Infosys3
what are file groups? Evalueserve3
How to create logins using windows Authentication mode?  2
Can you explain the role of each service?  1
Can we use Truncate command on a table which is referenced by FOREIGN KEY?  2
How do we return a record set from a Stored Procedure in SQl server 2000?  2
What are sub-queries? Give example? In which case sub-queries are not feasible? Infosys3
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
What is a function? Give some example?  2
Questions on identity? Infosys1
How do I list the available tables in a database I'm querying?  3
How to Debug a Stored Procedure? Allianz4
How do you find the error, how can you know the number of rows effected by last SQL statement?  2
Which virtual table does a trigger use? TCS6
What is the purpose of UPDATE STATISTICS?  1
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?  1
write the query for taking database restore in sql?  2
What types of integrity are enforced by a foreign-key constraint  1
What is MSDE?  2
 
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