We use SQL Server 2012, SSIS 2012 and Visual Studio 2012.
Our target is to send data to the Azure system. For this, we did the steps on the following website, Azure Feature Pack Setup was installed, Java was installed, TLS 1.2 was set.
https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15
I developed and tested the ETL package in Visual Studio on my local computer. I have tested it many times.
I used "Flexible File Destination" for data submission. Source: Oracle Database, Destination: Azure- "Flexible File Destination".
I requested an installation on the SSIS server. Installations have been made. Azure Feature Pack was installed on the SSIS server, Java was installed, TLS 1.2 setting was made. There is no incomplete installation. But after deployed, I run the package from SSIS catalog, it waits for a long time and gives an error.
In summary, we do not do the deploy process to the azure system. We do the deploy operation to the usual SQL Server 2012/SSIS 2012.
Sent To Data - xxlx3exxb99 - DEV_PROJE 27.04.2021 11:18 27.04.2021 12:38 4,822 80 Transfer data error : Microsoft.DataTransfer.Common.Shared.HybridDeliveryException: ADLS Gen2 operation failed for: Object reference not set to an instance of an object.. Account: 'xxlx3exxb03'. FileSystem: 'xxxxxxxxx'.. ---> Microsoft.DataTransfer.Common.Shared.HybridDeliveryException: Object reference not set to an instance of an object. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.IdentityModel.Clients.ActiveDirectory.Internal.Http.AdalHttpClient.<GetResponseAsync>d_22`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.IdentityModel.Clients.ActiveDirectory.Internal.Http.AdalHttpClient.<GetResponseAsync>d_22`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---