May 21, 2018 at 10:32 am
Hi there,
I m trying to get data out from our AD server using SSIS and Studio 2013
Have created a Data flow task and ADO Net Source where i write my LDAP query but i get this error does anyone have a clue what is it ?
[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. 'ADsDSOObject' failed with no error message available, result code: -2147016669(0x80072023).
I followed the article https://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx
Any help will be much appreciated
May 21, 2018 at 11:55 am
zouzou - Monday, May 21, 2018 10:32 AMHi there,I m trying to get data out from our AD server using SSIS and Studio 2013
Have created a Data flow task and ADO Net Source where i write my LDAP query but i get this error does anyone have a clue what is it ?
[ADO NET Source [2]] Error: The ADO NET Source was unable to process the data. 'ADsDSOObject' failed with no error message available, result code: -2147016669(0x80072023).I followed the article https://social.technet.microsoft.com/wiki/contents/articles/1293.processing-active-directory-information-in-ssis.aspx
Any help will be much appreciated
The error is usually from exceeding the MaxPageSize limit (defaults to 1000) for LDAP queries. Whether changing that or not is a good idea has been debated before. I'd try to refine the query to get less data if possible.
Sue
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply