Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37686 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 are functions in the sql server?
Which is the main third-party tool used in sql server?
What is implicit mode in sql server?
What is the difference between DATETIME2 and DATETIME?
How to create a view with data from multiple tables?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Give me a SQL Query to find out the second largest company?
How to select an exiting database using mssql_select_db()?
What do you understand by the data quality services in sql server?
Explain sql server authentication modes?
Explain difference between cross join and full outer join?
What is code near application topology?
Write a sql query to sort on different column name according to the parameters passed in the function?
What's new in sql management studio for sql server? : sql server management studio
What are recommended options to be used while using db mirroring? : sql server database administration
