What is the difference between DTS and SSIS?
- 3 Answers
- 35860 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
How do I find my localdb version?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Why main is user defined function?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How to generate random numbers with the rand() function in ms sql server?
What are rows and columns?
Explain the properties of a relational table?
Define clusters?
what are user defined datatypes? : Sql server database administration
Why we use functions in sql server?
Which tools are available to manage SQL Azure databases and servers?
How to create a store procedure with encryption?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is sql server profiler trace data file?
