none
Processing data from ADO .NET Active Directory source fails

    Question

  • I want to get data from Active Directory and insert it into an SQL server table using SSIS. 
    Using this very helpfull link http://agilebi.com/cs/blogs/jwelch/archive/2007/04/07/retrieving-information-from-active-directory-with-ssis.aspx this is what I did:

    1. Created an ADO.NET connection with .Net Provider for OleDb\OLE DB Provider for Microsoft Directory Services.
    2. Created an OleDb connection with Native OLE DB\SQL Native Client.
    3. Drop a Data Flow Task on the Control Flow.
    4. Drop a DataReader Source that uses the ADO.NET connection on the Data Flow. I used a SqlCommand like 
        Select cn  'LDAP://DC=domainname,DC=com' Where objectClass='User'
        Pushing the preview button displays a warning about the data type not being supported and that it will be converted to DT_NTEXT.
        But then the preview displays records just fine.
    5. Drop a OLE DB Destination that uses OleDb connection on the Data Flow.
    6. Performed data conversions.
    5. Connect the Data Conversion task and the OLE DB Destination and mapped the columns.
    6. Execute the Data Flow Task.

    This results in the following error, on the ADO .NET source:

    Error: 0xC02090F5 at DFT Load AD into MasterData, ADO_SRC ActiveDirectory [1]: The component "ADO_SRC ActiveDirectory" (1) was unable to process the data. 'ADsDSOObject' failed with no error message available, result code: -2147016669(0x80072023).

    Error: 0xC0047038 at DFT Load AD into MasterData, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ADO_SRC ActiveDirectory" (1) returned error code 0xC02090F5.

    I was not able to find usefull information about these errors :-(
    Any ideas?
    Wednesday, October 28, 2009 10:57 AM

All replies