70-463 · Question #183
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…
The correct answer is C. Script component configured as a source. A Script component configured as a source is the best choice because it lets you write custom .NET code using System.DirectoryServices to recursively traverse the Active Directory hierarchy, then emit each user record as a row directly into the SSIS Data Flow pipeline. The rows…
Question
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?
Options
- AScript task
- BScript component configured as a transformation
- CScript component configured as a source
- DScript component configured as a destination
How the community answered
(44 responses)- A2% (1)
- B14% (6)
- C77% (34)
- D7% (3)
Explanation
A Script component configured as a source is the best choice because it lets you write custom .NET code using System.DirectoryServices to recursively traverse the Active Directory hierarchy, then emit each user record as a row directly into the SSIS Data Flow pipeline. The rows flow naturally into a downstream OLE DB or ADO.NET destination pointed at the SQL Server table - no extra plumbing is needed. A Script task (A) could download the data but would require additional effort to pass records into a data flow. A Script component as a transformation (B) requires an upstream source to already exist. A Script component as a destination (D) is for writing data, not reading from Active Directory.
Topics
Community Discussion
No community discussion yet for this question.