connection error Magento SSIS

[[email protected]]

I am consulting the products through SSIS but when starting the task it fails and delivers the error:

[Devart Magento Source [2]] Error: Devart.Data.Magento.MagentoException (0x80004005): Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.
---> Devart.Data.Magento.MagentoException (0x80004005): Anulada la solicitud: No se puede crear un canal seguro SSL/TLS. ---> System.Net.WebException: Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.
en System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
en System.Net.HttpWebRequest.GetRequestStream()
en Devart.Data.Rest.c.hg(String A_0, String A_1, Stream A_2, String A_3, Dictionary`2 A_4, h A_5, Nullable`1 A_6, Nullable`1 A_7, Nullable`1 A_8, String A_9)
en Devart.Data.bb.a[a](Boolean A_0, Int32 A_1, Func`1 A_2)
en Devart.Data.bb.i()
en Devart.Data.bb.i()
en Devart.Data.bx.b()
en Devart.Data.ca.bo4(b A_0, Object A_1, f A_2)
en Devart.Common.Devart.Data.SqlShim1319268.w.a(v A_0, b A_1, f A_2)
en Devart.Common.Devart.Data.SqlShim1319268.v.a(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.v.b(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.w.c(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.y.bqy(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.f.Open()
en Devart.Data.Magento.c.Open()
en Devart.SSIS.SqlShim.CommonConnectionManager.AcquireConnection(Object txn)
en Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn)
en Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
en Devart.SSIS.SqlShim.BaseComponent.AcquireConnections(Object transaction)
en Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

thanks for your help!

[Pinturiccio]

Looks like your Magneto server requires TLS 1.1 or higher. There are 2 ways to force using TLS 1.1 or higher.
I. Add a specific code inside SSIS Data Flow Components for Magento. We will investigate the possibility to force using TLS 1.1 or higher in SSIS Data Flow Components for Magento and post here when we get the results.

II. Add two keys to the registry. After these changes you can use the current version of SSIS Data Flow Components for Magento.
1. Click "Win key + R" and enter regedit. Click Ok: http://prntscr.com/k4onxy
2. Copy and paste "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319" (without quotes) to the path panel and press Enter. http://prntscr.com/k4oow0
3. Right Click the right panel and select New->DWORD (32-bit) Value. http://prntscr.com/k4oqzy
4. Name it SchUseStrongCrypto. http://prntscr.com/k4orkr
5. Double-click this new parameter, set its value to 1, and click Ok. http://prntscr.com/k4osvw
6. Repeat steps 2-5 with the following path on the step 2:"HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319" (without quotes).
7. Restart SQL Server Data Tools.

Is the issue fixed after this?

[[email protected]]

I work perfect only with step two .... thank you very much!

[Pinturiccio]

Please note, that the second way affects all .NET applications. We added the needed code to SSIS Data Flow Components for Magento. The next public build will works even without adding described entries to the registry.

New build of Devart SSIS Data Flow Components 1.10.979 is available for download now!
It can be downloaded from https://www.devart.com/ssis/download.html or from Devart Account (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38984