Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

Reading from Active Directory using SSIS

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on May 23, 2011

Fellow MSDN blogger http://blogs.msdn.com/b/alextch/ has http://blogs.msdn.com/b/alextch/archive/2011/05/15/active-directory-data-from-extract-load-and-transform-etl-perspective.aspx 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

Updated Mar 25, 2019
Version 2.0
No CommentsBe the first to comment