Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37523 Views
- Allianz, I also Faced
- E-Mail Answers
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
What is resultset concur_updatable?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What are filegroups in sql server?
How secure is sql server database?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is query optimizer in sql server?
What is read uncmmited?
what is normalization? Explain different levels of normalization? : Sql server database administration
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What are logical/boolean operations in ms sql server?
Can group by be used without aggregate functions?
What are the new scripting capabilities of ssms? : sql server management studio
How to stop a loop early with break statements in ms sql server?
What is the difference between lock, block and deadlock? : sql server database administration
