Which item should you use?

To support the implementation of new reports, Active Directory data will be downloaded to a
SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL
Server table.
The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development
effort.
Which item should you use?

To support the implementation of new reports, Active Directory data will be downloaded to a
SQL Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL
Server table.
The download process must traverse the Active Directory hierarchy recursively.
You need to configure the package to meet the requirements by using the least development
effort.
Which item should you use?

A.
Script task

B.
Script component configured as a transformation

C.
Script component configured as a source

D.
Script component configured as a destination



Leave a Reply 1

Your email address will not be published. Required fields are marked *