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 is heavily oriented towards Windows and PowerShell. All automation and scripting examples use PowerShell, with no mention of Bash, Azure CLI, or cross-platform scripting alternatives. The use of SQL Server Management Studio (a Windows-only tool) is recommended for verification. There are no Linux-specific instructions or examples, and the documentation assumes the use of Windows-centric tools and workflows throughout.
Recommendations:
- Provide equivalent examples using Azure CLI and Bash scripts for starting, stopping, and monitoring Azure-SSIS IR, alongside PowerShell.
- Include instructions for verifying SSIS package execution using cross-platform tools or Azure Portal, not just SQL Server Management Studio.
- Mention and demonstrate how to use REST API calls via curl or other cross-platform tools for automation.
- Clarify that PowerShell Core is available cross-platform, but also provide Bash/CLI alternatives for Linux users.
- Review all screenshots and UI instructions to ensure they are not exclusive to Windows environments, or provide notes for Linux/macOS users where UI may differ.
Create pull request
Scan History
| Date | Scan ID | Status | Bias Status |
|---|---|---|---|
| 2025-09-08 00:00 | #105 | completed | ✅ Clean |
| 2025-08-17 00:01 | #83 | in_progress | ✅ Clean |
| 2025-07-13 21:37 | #48 | completed | ✅ Clean |
| 2025-07-09 13:09 | #3 | cancelled | ✅ Clean |
| 2025-07-08 04:23 | #2 | cancelled | ❌ Biased |
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 #####"