Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Retriving data from active directories using ssis RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have to load data from active directory. so I have taken ADO.net Source  and used the below query to load data:

    SELECT distinguishedName,wfc-EmplId,mail, displayName, name,sAMAccountName
    FROM 'LDAP://.......'
    WHERE whencreated>='20190813000000.0Z'

    this query is returning an error:

    ADsDSOObject failed with no error message available ...

    but if I modify the query as below :

    SELECT distinguishedName,wfc-EmplId,mail, displayName, name,sAMAccountName
    FROM 'LDAP://....'
    WHERE whencreated>='20190815000000.0Z' and sAMAccountName ='U123456'

    resulting output as expected because with this above combination we don't have more records. 

    but if I remove the accountname condition query returning error. 

    can anyone explain how to proceed.

    Thanks in advance.



    Friday, August 16, 2019 12:59 PM

Answers

All replies