Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problem reading via OleDB provider for MS Directory Services Expand / Collapse
Posted Tuesday, May 6, 2014 2:17 AM


Group: General Forum Members
Last Login: Wednesday, November 23, 2016 10:22 AM
Points: 117, Visits: 234

I was asked to get information from AD.

I have a connection of type: OleDB provider for MS Directory Services

and the preview works OK and returns the correct info:

SELECT employeeid, sAMAccountName
FROM 'LDAP://DC=xxxxx,DC=ad'

BUT when I run the package it gives:

Error: 0xC02090F5 at Data Flow Task, ADO NET Source [2]: The ADO NET Source was unable to process the data. 'ADsDSOObject' failed with no error message available, result code: -2147016669(0x80072023).[/right]

I found this URL about the issue:

Is the script method really the only way to accomplish this...?

Post #1567827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse