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
BUT when I run the package it gives:
Error: 0xC02090F5 at Data Flow Task, ADO NET Source : 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...?