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!

How to rebuild the master database?

748

---

Explain an automatic checkpoint

720

---

Explain Capacity planning to create a database? and how to monitor it?

3949

---

What are transactions and its controls?

796

---

what is an extended stored procedure? : Sql server database administration

708

---

---

Tell me what is difference between view and materialized view?

692

---

How to join two tables in a single query in ms sql server?

715

---

Mention a few common trace flags used with sql server?

677

---

What is the simplest way to create a new database in ms sql server?

729

---

What is normalization of database? What are its benefits?

680

---

How to retrieve field values using mssql_result()?

808

---

Please explain go command in sql server?

776

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

704

---

ow to bring suspect mode datbase online from scratch

1573

---

What is the difference between locking and multi-versioning?

720

---