Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DTS and SSIS?
- 3 Answers
- 37539 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 does dml stand for?
What is data source in connection string?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is sql server programming?
How to add the custom code in Report?
How can I track the changes or identify the latest insert-update-delete from a table?
How can we determine what objects a user-defined function depends upon?
What are the various editions of sql server 2017 that are available in the market?
What are the advantages to use stored procedures?
How would we use distinct statement? What is its use?
what type of index will get created after executing the above statement? : Sql server database administration
Where is trigger in sql server?
What is meant by indexing files?
What is the xml datatype?
How to receive output values from stored procedures?
