Ssis-913 Site

To resolve the SSIS-913 error, follow these troubleshooting steps:

$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

To minimize the occurrence of SSIS-913 errors, follow these best practices: To resolve the SSIS-913 error, follow these troubleshooting

The SSIS-913 error is usually related to package execution failures. SSIS error codes can be very specific or quite generic, and the SSIS-913 error falls into the latter category. It might be accompanied by additional information in the error message that can help diagnose the problem. If the basic troubleshooting steps don't resolve the

If the basic troubleshooting steps don't resolve the issue, you can try: