Error while upload the data to Blob after updating Blob TLS 1.2

Have you amended the registry as per the documentation?

https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#use-tls-12

Use TLS 1.2
The TLS version used by Azure Feature Pack follows system .NET Framework settings. To use TLS 1.2, add a REG_DWORD value named SchUseStrongCrypto with data 1 under the following two registry keys.
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft.NETFramework\v4.0.30319
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft.NETFramework\v4.0.30319

@Matthew Foody @Sumarigo-MSFT @deherman-MSFT Can you please help me?

After adding required registry keys, its SSIS Package execution is working as expected. But, failing after SSIS Package deployment in SQL MI - SSIS DB while running from ADF and getting same error.

Hi @Vikas , Did you manage to resolve this issue anytime?

{
"SsisDBOperationGuid": "4c69f532-8224-44df-9362-2f6f53d4dbfe",
"SsisDBOperationId": 3,
"OperationErrorMessages": "1/11/2022 6:24:56 PM +00:00 : Data Flow Task:Error: Cannot find the file specified. Folder path: 'input', File filter: 'ProductTest.csv'.\n1/11/2022 6:24:57 PM +00:00 : Data Flow Task:Error: Microsoft.DataTransfer.Common.Shared.HybridDeliveryException: Cannot find the file specified. Folder path: 'input', File filter: 'ProductTest.csv'. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Azure.Storage.Common, Version=11.1.3.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.\r\n at Microsoft.Azure.Storage.Data.ExceptionHandler.SetStorageExceptionContext(Exception ex, Dictionary2 exData)\r\n at Microsoft.Azure.Storage.Data.ExceptionHandler.HandleException(Exception ex, String fileSystem, String path)\r\n at Microsoft.Azure.Storage.Data.ExceptionHandler.ExecuteAction[TResult](Func1 func, String fileSystem, String path)\r\n at Microsoft.Azure.Storage.Data.BlobFSClient.GetItemStatus(String filesystem, String path)\r\n at Microsoft.DataTransfer.Runtime.BlobFSMultipartReadable.get_Length()\r\n at Microsoft.DataTransfer.ClientLibrary.MultipartReadSource.OpenStream(IMultipartReadable readable)\r\n at Microsoft.DataTransfer.ClientLibrary.MultipartReadSource.Read()\r\n --- End of inner exception stack trace ---\r\n at Microsoft.DataTransfer.ClientLibrary.MultipartReadSource.Read()\r\n at Microsoft.SqlServer.IntegrationService.ExtensibleFileCommon.DataTransferClientHelper.GetTabularReadResult(IDictionary`2 sourceProperties, Guid transferId, Guid activityId)\r\n at Microsoft.SqlServer.IntegrationService.ExtensibleFileComponents.Source.ExtensibleFileSource.GetExternalTabularSourceReader()\r\n at Microsoft.SqlServer.IntegrationService.ExtensibleFileComponents.PipelineComponentSource.TransferToOutputBuffers(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)\n",
"effectiveIntegrationRuntime": "Azure-SSIS-IR (UK South)",
"executionDuration": 13,
"durationInQueue": {
"integrationRuntimeQueue": 0
}
}

Hi All,

I managed to resolve this Storage account access issue from following.

1. VS Studio Runtime , errors can be resolved by adding registry keys as required.
2. In ADF/Azure SQL Server / MI Runtime, errors can be resolved by granting right access permission to blob. In my case, I have to establish private end point connection between Azure-SSIS-IR subnet and blob storage.