Devart Forums

This pulls around 50,000 rows and then throws this error. Not sure what the problem would be or where to start.

"Lists Members:Error: Devart.Data.MailChimp.MailChimpException (0x80004005): The remote server returned an error: (500) Internal Server Error.
at Devart.Data.fa.InvokeApiCall[T](Boolean authorizedCall, Func`1 call)
at Devart.Data.MailChimp.cb.a(String A_0, String A_1, Stream A_2)
at Devart.Data.MailChimp.cb.c(a A_0, bw A_1)
at Devart.Data.MailChimp.cr.d()
at Devart.Data.e7.a()
at Devart.Data.fl.a()
at Devart.Data.gb.e()
at Devart.SSIS.SourceComponent.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)"

Try increasing the 'Default Command Timeout' value in your MailChimp connection. It can be done on the Advanced tab of the connection editor.