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


All replies