Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37251 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
Which is better statement or preparedstatement?
what is the system function to get current user's user id? : Sql server database administration
What is the server name for sql management studio?
How do I debug a stored procedure in sql server?
What are logical/boolean operations in ms sql server?
Why use triggers?
What are types of subqueries?
How do you troubleshoot errors in a SQL Server Agent Job?
Can we linked SharePoint to a SQL database?
last function used in MS Access to convert sql what function will use in sql
Why union all is faster than union?
Difference between report and query parameter.
What causes index fragmentation?
How to optimize stored procedure optimization?
What stored procedure would you use to view lock information?
