Document Details
How To Schedule Azure Ssis Integration Runtime
❌
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Bias Types:
⚠️
powershell_heavy
⚠️
windows_tools
⚠️
missing_linux_example
⚠️
windows_first
Summary:
The documentation demonstrates a strong Windows and PowerShell bias. All scripting and automation examples are provided exclusively in PowerShell, with no mention of Bash, Azure CLI, or cross-platform alternatives. The use of Windows-centric tools such as SQL Server Management Studio (SSMS) is assumed for verification steps. There is no guidance for users on Linux or macOS, and no examples using platform-agnostic tools or commands. The documentation also references PowerShell modules and Azure Automation runbooks in PowerShell without offering equivalent instructions for other environments.
Recommendations:
- Provide equivalent examples using Azure CLI (az) commands for starting, stopping, and monitoring Azure-SSIS IR, as Azure CLI is cross-platform.
- Include Bash script examples for automation tasks, especially for scheduling via cron or using Azure CLI in Linux/macOS environments.
- Mention and provide steps for using Data Factory REST APIs directly with curl or other HTTP clients, which are platform-neutral.
- For verification steps, suggest alternatives to SQL Server Management Studio, such as Azure Data Studio (cross-platform) or querying via sqlcmd.
- Clarify in prerequisites and throughout the guide that all steps can be performed from Linux/macOS using Azure CLI and REST APIs, not just from Windows/PowerShell.
- Where PowerShell is referenced, explicitly note that it is available cross-platform, but also provide syntax for native shells (Bash, zsh, etc.) where possible.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-07-12 23:44 | #41 | in_progress | ❌ Biased |
| 2025-07-12 00:58 | #8 | cancelled | ✅ Clean |
| 2025-07-10 05:06 | #7 | processing | ✅ Clean |
Flagged Code Snippets
Get-AzDataFactoryV2PipelineRun -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -PipelineRunId $myPipelineRun
Get-AzDataFactoryV2Trigger -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -Name "myTrigger"
Get-AzDataFactoryV2TriggerRun -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -TriggerName "myTrigger" -TriggerRunStartedAfter "2018-07-15" -TriggerRunStartedBefore "2018-07-16"
Param
(
[Parameter (Mandatory= $true)]
[String] $ResourceGroupName,
[Parameter (Mandatory= $true)]
[String] $DataFactoryName,
[Parameter (Mandatory= $true)]
[String] $AzureSSISName,
[Parameter (Mandatory= $true)]
[String] $Operation
)
$ErrorActionPreference = "Stop"
try
{
"Logging in to Azure..."
Connect-AzAccount -Identity
}
catch {
Write-Error -Message $_.Exception
throw $_.Exception
}
if($Operation -eq "START" -or $operation -eq "start")
{
"##### Starting #####"
Start-AzDataFactoryV2IntegrationRuntime -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -Name $AzureSSISName -Force
}
elseif($Operation -eq "STOP" -or $operation -eq "stop")
{
"##### Stopping #####"
Stop-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
}
"##### Completed #####"