Client timeout exception

Apr 24, 2014 at 2:38 PM

When executing the LDAP SSIS Source, I am getting a client timeout error.

I tried to recompile the source changing some properties (SearchRequest.TimeLimit, LdapConnection.Timeout, etc...) but it has no effect.

Does anyone have an idea for a workaround ? Or anyone know what is the correct property in order to change the client timeout in S.DS.P namespace.

Thank you

The exception is :

[LDAP Source [228]] Error: System.DirectoryServices.Protocols.LdapException: The operation was aborted because the client side timeout limit was exceeded.
à System.DirectoryServices.Protocols.LdapConnection.ConstructResponse(Int32 messageId, LdapOperation operation, ResultAll resultType, TimeSpan requestTimeOut, Boolean exceptionOnTimeOut)
à System.DirectoryServices.Protocols.LdapConnection.SendRequest(DirectoryRequest request, TimeSpan requestTimeout)
à System.DirectoryServices.Protocols.LdapConnection.SendRequest(DirectoryRequest request)
à DirectoryServicesProtocolsExtensions.SearchRequest.PagedSearchRequest.<Execute>d__0.MoveNext()
à SsisLdapSource.SsisLdapSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] pipelineBuffers)
à Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)