I am connecting ADAM[Active directory in application mode] using SSIS using OLEDB connection manager. I have created SQL/LDAP query "SELECT cn, displayName, descriptionFROM 'LDAP://localhost:389/O=myContainer'WHERE displayName = 'xxx' This query displays proper data in query builder when I run the query.But when I say OK on OLEDB source manager it gives following error =================================== Error at Data Flow Task [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E21. (Microsoft Visual Studio) =================================== Exception from HRESULT: 0xC0202009 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------Program Location: at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData() at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata() at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object sender, ConnectionAttributesEventArgs args) Also if above query is modified to Select * FROM 'LDAP://localhost:389/O=myContainer' , it only returns adsPath. Can anyone help what is wrong in this?

Any updates?

1) Are you using OLE DB provider for Microsoft directory services ? 2) Microsoft Directory Services does not support LDAP queries directly from SSIS, so you need to use open query . http://msdn2.microsoft.com/en-us/library/ms190803.aspx http://msdn2.microsoft.com/en-us/library/ms135937.aspx

You would need to use an ADO.Net connection manager, like this: http://dataqueen.unlimitedviz.com/2012/05/importing-data-from-active-directory-using-ssis/<o:p></o:p> But the most flexible and robust way to import data from Active Directory is to use a script task, since you won't run into AD paging file size issues and you can import multi-value attributes such as Description. Here is a step-by-step: http://dataqueen.unlimitedviz.com/2012/09/get-around-active-directory-paging-on-ssis-import/<o:p></o:p> Cheers, Martina Martina White