Devart Forums

We started getting the error below when trying to run our SSIS packages. It's happening across all packages using the Devart BigQuery Destination. It was all working fine until this morning. We tried on a couple machines and get the same error. We are running the latest version of the SSIS components and have tried uninstalling and reinstalling everything. Any ideas on what we can try to resolve this?


SSIS package "C:\Development\SSISOpenPackage\SSISOpenPackage\TD_GCP_COPY.dtsx" starting.
Information: 0x4004300A at sd_dg_parameters, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at sd_dg_parameters, Devart BigQuery Destination [20]: Devart.Data.BigQuery.BigQueryException (0x80004005): The underlying connection was closed: An unexpected error occurred on a receive. ---> Devart.Data.BigQuery.BigQueryException (0x80004005): The underlying connection was closed: An unexpected error occurred on a receive.
at Devart.Data.t.a[a](Boolean A_0, Int32 A_1, Func`1 A_2)
at Devart.Data.t.bm3()
at Devart.Data.t.bm3()
at Devart.Data.z.a(v A_0)
at Devart.Data.w.bm5(k A_0, Object A_1, d A_2)
at Devart.Common.Devart.Data.SqlShim1293377.i.a(l A_0, k A_1, d A_2)
at Devart.Common.Devart.Data.SqlShim1293377.l.a(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.l.b(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.i.c(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.h.bni(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.d.Open()
at Devart.Data.BigQuery.y.Open()
at Devart.SSIS.SqlShim.CommonConnectionManager.AcquireConnection(Object txn)
at Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
at Devart.SSIS.SqlShim.BaseComponent.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
Error: 0xC0047017 at sd_dg_parameters, SSIS.Pipeline: Devart BigQuery Destination failed validation and returned error code 0x80004005.
Error: 0xC004700C at sd_dg_parameters, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at sd_dg_parameters: There were errors during task validation.
SSIS package "C:\Development\SSISOpenPackage\SSISOpenPackage\TD_GCP_COPY.dtsx" finished: Failure.

As I remember you already had a similar problem (viewtopic.php?t=46701) and the issue successfully resolved by changing some network settings (adding a proxy server and port).

The most likely reason is some network issues not related to the Devart provider. Check your network configuration or firewall settings.