I want to use SSIS to query AD and make the data available in data flow. I
am using the "OLE DB Provider for Microsoft Directory Services" and I can get
the query to parse, but get an error when trying to preview the data. This
is the query I'm using:

SELECT cn, distinguishedname
FROM 'LDAP://otisldap.spunkmeyer.com/DC=spunkmeyer,DC=com'
WHERE objectClass = 'computer' order by cn

I am trying to avoid using OpenQuery as I understand it limits the result
set to 1,000 rows and I have more data than that. I could write a .NET app
but it seems like SSIS should be able to handle this.

Any suggestions (on this topic) are welcome!

-- Brian

Brian,

What error message do you get?

Andrew Watt MVP

On Tue, 9 May 2006 10:06:01 -0700, Brian Shelden
<BrianShelden (AT) discussions (DOT) microsoft.com> wrote:

When I click the Preview button, I get an error dialog with these two messages:

Error at Data Flow Task [OLE DB Source]:
An OLE DB error has occured.
Error code: 0x80040E21

Additional information:
Exception from HRESULT:
0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap

Thanks!