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.
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2012 1:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics