How to extract information from Active Directory


  • Hello,

    I want to extract user information from Active Directory and dump the results to a table or text file using SSIS. I created a Connection Manager pointing to a domain Controller and a corresponding SQL Command with the attributes I need. When I Select Preview I get below error for each attribute I try to collect. When I acknowledge the error (Click OK) the preview displays the columns requested. However, when I wire it up to dump it to a text document it simply fails with the same error. Does anyone know why this is happening?

    Warning at {480F2CFE-9691-46D6-8552-10A0B3028BD9} [ADO NET Source [75]]: The data type "System.Object" found on column "extensionAttribute1" is not supported for the component "ADO NET Source" (75). This column will be converted to  DT_NTEXT.



    Tuesday, March 15, 2011 8:30 PM


  • Forum:


    Please mark the post as answered if it answers your question | My SSIS Blog:


    I found the answer within this forum post describing the SQL Table fields being of type NTEXT. When I changed their type I was able to pull 1,000 rows from AD. Now my NEW ISSUE is the limit of 1,000 rows being returned. In my DTS Package I was able to set the "Page Size" to 10,000 and all worked fine.

    I reviewed the MSDN LDAP article that mentions using either a group policy or a registry modification to set my MaxPageSize but neither of those worked. Is there another area in the connection manager that I can set the value programatically?



    • Marked as answer by jpaskett Tuesday, March 22, 2011 12:23 PM
    Monday, March 21, 2011 7:06 PM

All replies