Fellow MSDN blogger Alex Tcherniakhovski has posted a presentation about retrieving Active Directory data using SSIS. His packages make use of a custom Active Directory Domain Source component which he built and published on his blog. The presentation does more than just show off this new source component – he also provides a good overview of SSIS, and the security/business case for it (“detecting permission creep conditions within Active Directory”).

http://blogs.msdn.com/b/alextch/archive/2011/05/15/active-directory-data-from-extract-load-and-transform-etl-perspective.aspx