Test-sqmSSISPackageCompatibility

Cluster sqmSQLTool v1.8.2+

Validates SSIS package compatibility for SQL Server upgrades (2016 - 2025).

Examples

# Check deployed packages on target server

# Check deployed packages on target server
    Test-sqmSSISPackageCompatibility -SqlInstance "NewServer2025" -TargetVersion 2025

# Check old package files before deployment

# Check old package files before deployment
    Test-sqmSSISPackageCompatibility -PackagePath "C:\OldPackages" -TargetVersion 2025 -Recurse

# Compare deployed vs. backup packages

# Compare deployed vs. backup packages
    Test-sqmSSISPackageCompatibility -SqlInstance "NewServer2025" `
      -PackagePath "C:\OldPackages" -TargetVersion 2025

Get-sqmCertificateReport

Get-sqmCertificateReport

Get-sqmCertificateReport -SqlInstance "SQL01","SQL02" -WarningThresholdDays 180

Get-sqmCertificateReport -SqlInstance "SQL01","SQL02" -WarningThresholdDays 180

# Show only expiring certificates

# Show only expiring certificates
    Get-sqmCertificateReport -SqlInstance "SQL01" |
        Select-Object -ExpandProperty Certificates |
        Where-Object { 


    
    
    

    
    Test-sqmSSISPackageCompatibility - sqmSQLTool PowerShell Cmdlet Documentation
    
    
    
    

    
    
    
    
    
    
    

    
    
    
    
    

    
    

    


    
        
            🛢 sqmSQLTool
            
                Home /
                Commands /
                Test-sqmSSISPackageCompatibility
            
        
    

    
        
        
            Test-sqmSSISPackageCompatibility
            
                Cluster
                sqmSQLTool v1.8.2+
            
        

        
        
            Validates SSIS package compatibility for SQL Server upgrades (2016 - 2025).
        

        
        {{EXAMPLES_HTML}}

        
        
                        
                ← Previous Command
                Test-sqmSsasDirectoryPermissions
            
                        
                Next Command →
                Get-sqmTlsStatus
            
        
    

    
        sqmSQLTool Documentation · GitHub · powershelldba.de
        PowerShell SQL Server Administration Toolset by dtcSoftware
    

    


.ExpiryStatus -ne 'OK' } |
        Select-Object SqlInstance, DatabaseName, CertificateName, ExpiryDate, DaysRemaining, ExpiryStatus, Purpose

# Pipeline across multiple instances

# Pipeline across multiple instances
    'SQL01','SQL02','SQL03' | Get-sqmCertificateReport -OutputPath "D:\Reports\Certs"

← Previous Command

Test-sqmSsasDirectoryPermissions

Next Command →

Get-sqmTlsStatus