What is the difference between DTS and SSIS?
- 3 Answers
- 36112 Views
- Allianz, I also Faced
- E-Mail Answers
Answer Posted / rajesh s. chandan
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 ? | 25 Yes | 2 No |
Post New Answer View All Answers
What is the purpose of linked server configuration in sql server?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How retrieve field names from the table in SQL through JAVA code?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is log in sql server?
What is the beast way to write CTE in SQL Server ?
How to delete existing rows in a table?
What are the advantages of using a stored procedure?
What are exact numeric data types in ms sql server?
what is a self join? : Sql server database administration
How many tables can be joined in SQL Server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
If user is owning any SQL Objects, can we drop that user
Do I need a report server to run reports in my application?
Define self join?
