Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37252 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 unique and xaml nonclustered index
How to install sql server 2005 express edition?
How can I tell if sql server is 32 or 64 bit?
How can we determine what objects a user-defined function depends upon?
What is the difference between indexing and hashing?
How to encrypt Strored Procedure in SQL SERVER?
How do you create a clustered index?
What is multi-statement table-value user-defined function?
What happens if null values are involved in bitwise operations?
What type of Index will get created after executing the above statement?
Give an example of why you would want to denormalize a database
How to use old values to define new values in update statements in ms sql server?
How to drop an existing stored procedure in ms sql server?
please differentiate between delete and truncate?
How to achieve Paging of records in SQL SERVER?
