Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, May 6, 2014 2:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 7, 2014 7:08 AM
Points: 103, Visits: 200
Hi,

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:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/fb1b3010-7861-430d-857a-49f7a9b0ecfb/processing-data-from-ado-net-active-directory-source-fails?forum=sqlintegrationservices

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

Ville
Post #1567827
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse