Ssis-913 (2027)

: Ensure all connections, variables, and configurations are correctly set up. Sometimes, a simple refresh or reconfiguration of these elements can resolve the issue.

$files = Get-ChildItem -Path $PackageFolder -Filter *.dtsx -Recurse foreach($file in $files) [xml]$xml = Get-Content $file.FullName $sources = $xml.SelectNodes("//DTS:Executable[@DTS:refId]//DTS:Component[@DTS:ComponentClassID='...OleDbSource...']", $null) foreach($src in $sources) $sql = $src.SelectSingleNode(".//DTS:Property[@DTS:Name='SqlCommand']").'#text' $validate = $src.SelectSingleNode(".//DTS:Property[@DTS:Name='ValidateExternalMetadata']").'#text' if($sql -match 'SELECT\s+\*' -and $validate -eq 'True') Write-Host "Potential SSIS‑913: $($file.FullName) – OLE DB Source uses SELECT *" -ForegroundColor Yellow SSIS-913

| Action | How‑to | |--------|--------| | | In the connection string, add Connect Timeout=120 (or larger) and Network Library=DBMSSOCN for TCP. | | Disable idle‑connection timeout on firewalls | Work with network team to set the firewall rule to “no idle timeout” for the source/destination IP/port. | | Use a Reliable IR (Azure Data Factory) | Ensure the Self‑Hosted Integration Runtime runs as a Windows Service with Automatic (Delayed Start) and has a heartbeat interval ≤ 30 seconds. | | Add retry logic | Wrap the Data Flow in a Foreach Loop that retries up to 3 times, or enable “MaximumErrorCount” on the package to allow retries. | | Validate DNS | Replace server name with its IP address in the connection string (temporary test) to rule out DNS resolution problems. | : Ensure all connections, variables, and configurations are

For IT professionals and database administrators, the acronym stands for SQL Server Integration Services . This is a component of Microsoft SQL Server used for data migration, workflow applications, and ETL (Extract, Transform, Load) processes. Is SSIS-913 a Technical Error? | | Disable idle‑connection timeout on firewalls |