What is the difference between DTS and SSIS?
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 data source document?
Determine how to use the inserted and deleted pseudo tables?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is the use of sql profiler in sql server 2012?
What is difference between standardization and normalization?
What is transaction server consistency?
What is the purpose of linked server configuration in sql server?
What are the advantages of partitioning?
What is a covered index?
How to execute multiple stored procedures at one time in sql server?
Explain how many types of relationship?
What is difference between drop truncate and delete?
What are the different subsets of sql?
List all the types of user-defined functions?
How to get the query of a table in sql server?