Data Transfer from Active Directory to SQL Server
Hello,Is there a way of setting up a job, that will run periodically, that will transfer data (users, groups, ...) from Active Directory to SQL Server?Thank you.
November 29th, 2005 12:20pm
There is an ADSI OLE DB Provider that you should be able to use with SSIS. I've only used it as a Linked Server. Either way you implement it, your biggest challenges will be that the ADSI Provider never returns more than 1,000 rows, and that there is no mechanism for detecting deleted objects.
November 29th, 2005 1:25pm
I am sorry, but I am new to the SQL Server DTS stuff. Whould you be able to elaborate on the SSIS, and I am using SQL Server 2000. So, I could not find the ADSI datasource.Thank you.
November 29th, 2005 1:29pm
For other users out there trying to find the answer like I did, here is a step by step. http://dataqueen.unlimitedviz.com/2012/09/get-around-active-directory-paging-on-ssis-import/<o:p></o:p> Martina White
September 13th, 2012 1:58pm