Pause/Resume SQL Synapse using SSIS

DeeMu 1 Reputation point
2020-09-11T11:19:59.437+00:00

Hello,

We are working on creating an automation script where our SQL Synapse can be paused/resumed during a time window for cost savings. Basically we wanted to do it in SSIS using powershell becase we wanted to check if there are any queries running and we have a framework which can run some queries too.
We have created a simple PS script and created a service principal given access to the synapse. Basically when we try to run the script in SSIS, through visual studio debugger it runs fine. But when we deploy in catalog and trigger it, the script basically runs but nothing happens. Any experiences and suggestions. Our initial guess is that it must be with some kind of access.

P.S: We are running this in our SQL VM.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,422 questions
{count} votes