What is the difference between DTS and SSIS?
Answer Posted / ramesh
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 ? | 48 Yes | 11 No |
Post New Answer View All Answers
How to backup SQL Server Reporting Services ?
Do you know what is replace and stuff function in sql server?
How do clustered indexes store data?
What is the bookmark lookup and rid lookup?
Tell me what is use of except clause? How it differs from not in clause?
What are the new features are introduced in sql server 2012 reporting services?
What is rtm version in sql server?
What are the types of dml?
How can sql injection be stopped? : sql server security
What is a file group?
Which is faster statement or preparedstatement?
What is bit data type?
What is sql view?
How to create a trigger for insert only?
What is the temp table?