July 14, 2006 at 11:10 am
Can SSIS be used to import and export information to and from LDAP directories?
Can I use SSIS to add information to Active Directory? How about other LDAP directories?
If so, how is it done?
July 17, 2006 at 8:00 am
This was removed by the editor as SPAM
May 8, 2007 at 8:07 am
Hello,
I think there are different ways, how you can import data from AD into SQL Server in a SSIS package. One approach is to execute operating system commands and pipe there results in a file. These files can be read into the table. Example for this OS Commands are csvde and dsget ( perhaps ldif).
Another way is to make a program im visual basic or c# which use the ADSI interface.
I heard from an dll which make it possible from SQL Server 2005 to get the AD Data in a SQL table.
May 8, 2007 at 8:12 am
try this link. I am sorry that it is german but there must be an english one somewhere.
September 30, 2010 at 3:59 pm
I have not attempted exporting to Active Directory, but an import is possible. I am using an ADO.Net connection with the Directory Services driver. I then issue an LDAP query similar to the following to retrieve the fields I need:
Select
Name
,UserPrincipalName
,DisplayName
,givenName
,middleName
,sn
,employeeid
,distinguishedname
,company
,department
,UserAccountControl
,whenCreated
,whenChanged
,SAMAccountName
From 'LDAP://192.168.1.1/DC=COMPANY,DC=com' WHERE objectCategory = 'Person' AND objectClass= 'user' and sn = '*'
October 4, 2010 at 4:09 am
Scott Tobias-328717 (7/14/2006)
Can SSIS be used to import and export information to and from LDAP directories?
CanI use SSISto add information to Active Directory? How about other LDAP directories?
If so, how isit done?
try implementing your logic using Script Task...You can virtually create any component using the ST :-):-):-)
Raunak J
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply