SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path

Recently we ran into an interesting scenario where we had a SSIS package that contained a script task and inside the script task, we were making connections to Azure File Storage and pulling the data from the file. While running this SSIS package from Visual Studio – SQL Server Data Tools (SSDT) & after deploying…


SSIS Scale Out worker is not showing up in Worker Agents

  Understanding of the issue: Adding the scale out worker to the master shows successful but this does not show up in the SQL Server integration services – Manage Scale Out (ISManager). Also, this will not be added in [SSISDB].[internal].[worker_agents] Adding SSIS worker completes in the wizard as below After this finished, if we check…