70-463 · Question #175
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 requiremen
The correct answer is A. script component. A Script component in the SSIS data flow task allows a developer to write managed .NET code (C# or VB.NET) directly within the package using the System.DirectoryServices namespace to connect to Active Directory, traverse the group hierarchy recursively, and output user rows into
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. What should you use?
Options
- Ascript component
- Bcustom component
- CXML source
- Dscript task
How the community answered
(46 responses)- A72% (33)
- B9% (4)
- C4% (2)
- D15% (7)
Explanation
A Script component in the SSIS data flow task allows a developer to write managed .NET code (C# or VB.NET) directly within the package using the System.DirectoryServices namespace to connect to Active Directory, traverse the group hierarchy recursively, and output user rows into the data flow pipeline - all with minimal external infrastructure. This is less effort than building a fully custom component (B), which requires implementing SSIS pipeline interfaces, registering the component in the GAC, and handling design-time metadata separately. An XML source (C) cannot connect to Active Directory. A Script task (D) is a control flow object; it cannot act as a data source inside a Data Flow Task, so data could not flow directly from it into destination components.
Topics
Community Discussion
No community discussion yet for this question.