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)"
Getting The Remote Server Returned an (500) Internal Error
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Getting The Remote Server Returned an (500) Internal Error
Try increasing the 'Default Command Timeout' value in your MailChimp connection. It can be done on the Advanced tab of the connection editor.