Sync SQL Contacts Table with Active Directory
I am not sure if this is the medium for this question but I am sure someone will let me know if it isnt. We have a home grown access front end / sql back end database. In this database we have store all of our clients in a contacts table. I would like to push integrate these contacts from this table into a Microsoft Exchange Address list. From what I have found the easiest way to do this is to first sync the contacts table with external contacts in active directory. After that building the address lists is failry simple. So the first part is getting the contacts table to sync with Active Directory - this should be something that can either sync automatically or with a task on a regular basis so that updates to the SQL database will also update Active Directory external contacts. Can anyone point me in the right direction. Either powershell, other other tools that are provide by MS or third party apps if all else fails. Thanks John
July 21st, 2011 4:14pm

you can use a data flow task, and read data from sql server tables with OLEDB Source, and load it into active directory with script component as destination, you should write few lines of scripts in .NET language, These links are helpful: http://www.ianatkinson.net/computing/adcsharp.htm http://www.codeproject.com/KB/system/everythingInAD.aspxhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 22nd, 2011 3:06am

Any more information would be helpful. This is all from scratch so any direction would be appreciated.
July 22nd, 2011 10:14am

first go to start->microsoft sql server (version)->Business Intelligence development studio create new project of type Integration Service project in the control flow of package, add a Data flow task from tool box then double click on it and in the data flow tab, add an oledb source , and connect it to sql server source table then add script component as I suggested in previous post. SSIS has lots of aspects, and a small post can't describe it . if you want to get start with SSIS, read more here: http://msdn.microsoft.com/en-us/library/bb522535.aspxhttp://www.rad.pasfu.com My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 23rd, 2011 3:28am

I am alot further than I was. I have the source and destination and found a really good article that talks about this... http://social.technet.microsoft.com/wiki/contents/articles/processing-active-directory-information-in-ssis.aspx I am at the step that I need to create the contacts from the source - the examples i have found using c# just create user accounts which I dont want to do. Is there any chance you can give me a basic example of creating a contact with c#. Once I have the basics I can take it from there I think on adding all the other attributes. John
September 21st, 2011 5:15pm

Any help with the coding portion of this would be appreciated. Thanks! John
Free Windows Admin Tool Kit Click here and download it now
September 26th, 2011 11:31am

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

Other recent topics Other recent topics