Automating running PowerShell script which required Administrator elevation via SSIS
UPDATE (08 AUG 2016): I have updated this to use a SQL Server Agent Job instead of the Task Scheduler which proved to not be reliable. What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will snapshot a database using Xtreme IO from EMC. In…
SQL Server 2016, Uncategorized
0
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized