October 10, 2014 at 2:09 pm
Hi,
I have an issue where I need to connect one of our systems to Active Directory but the connection is pathetic at best. If I wanted to link these people regularly I would have to click "connect to Active Directory" in each persons user. I would much rather query Active Directory to create this connection.
I have one problem though. I am trying to use SSIS, I was using an ADO.net query that says "'SELECT objectGUID,distinguishedName,sAMAccountName FROM ''LDAP://xxx.xx/OU=xxx,DC=xxx,DC=xxx'' WHERE objectCategory=''user'' and whenCreated >=20141009000000.0Z'
Which works great (I might have some single quotes and double quotes missing in the query because I copied it from my test area not the SSIS) except that objectGUID shoots out "System.Byte[]" and I cannot find a way to convert or change this to be usuable as a uniqueIdentifier sql value.
Any ideas on what I need to do to make this work or if there are any other routes I should be taking to do this?
October 13, 2014 at 3:22 pm
For my own memory, I ended up resolving this by using an OLE DB Source with a linked server to Active Directory where the linked server is on the database that the SSIS package runs on.
I was unable use this type of a linked server remotely, I had to be on that machine connected to that database to run this successfully, It made testing difficult because i had to duplicate the conditions on my own development machine before deployment.
I also within the select statement case the GUID as a uniqueIdentifier.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy