question

Vikas-7600 avatar image
0 Votes"
Vikas-7600 asked ·

Getting TlsVersionNotPermitted error when SSIS package executing from ADF

Hi,
I have created one SSIS package which is reading data from Storage account and putting that into Azure DB. This is working perfectly well when executing from Visual Studio. But when I am triggering it after deployment in ADF, getting below error.
ForEachLoopContainer: Error: Com error object information is available. Source: "Microsoft.DataTransfer.ClientLibrary" error code: 0x80131500 Description: "ADLS Gen2 operation failed operation returned an invalid status code "Bad request".
ErrorCode: "TlsVersionNotPermitted"
message: TLS version of this connection is not permitted on this storage account.
I can see that Storage account has TLS version 1.2
Can someone please help.

azure-data-factoryazure-storage-accountsazure-data-lake-storage
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MartinJaffer-MSFT avatar image
0 Votes"
MartinJaffer-MSFT answered ·

Hello @Vikas-7600 and welcome to Microsoft Q&A.

I understand this would be very frusterating. There are a few possible causes. Can you tell me if you are using a self-hosted integration runtime to get to a Storage account inside a vnet?

If not, there are a couple options. You could try lowering the Storage account TLS version, or you could try enabling stronger TLS on the SSIS Integration Runtime (instructions for configuring here). Add to your main.cmd:

 reg add HKLM\SOFTWARE\Microsoft\.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64
 reg add HKLM\SOFTWARE\Microsoft\.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32



· 3 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @MartinJaffer-MSFT After setting TLS version to 1.0 it's working for me. But when I am connecting with FileShare storage, it's working fine using Visual Studio but after deploying it to ADF it's not working saying validation failed, path incorrect. Can you please guide me where I am doing wrong.
I have create SSISIR and setup a catalogue DB, I am not using SelfHostedIR. I tried with selfhosted but not sure how it will work with SSIS package, it's working fine with COPYTO option using Linked Services.
Kindly provide some reference to use Fileshare/Local network drive using SSIS after deploying to ADF.

0 Votes 0 ·

@Vikas-7600 Was the FileShare working before you changed the TLS version, or is the difficulty unrelated to the TLS change?

0 Votes 0 ·

@Vikas-7600 if the FileShare issue is unrelated to the fix for the TLSversionnotPermitted error, please ask in a new question.

If the FileShare issue was caused by the fix please let me know.

0 Votes 0 ·