SSIS Package Compatibility - ETL_DailyLoad.dtsx

Target: SQL Server 2022 | 2026-07-19 16:24:00
Source: www.powershelldba.de | sqmSQLTool v1.9.26.1
Illustrative example — this lab environment has no sample .dtsx package to validate. Values below are representative, not measured output.

Checks run: 5 | Passed: 3 | Warning: 1 | Failed: 1

PackageCategoryCheckStatusMessageSource
ETL_DailyLoad.dtsxConnection ManagerOLE DB ProviderFailedSQLNCLI11 provider is deprecated on SQL Server 2022 - replace with MSOLEDBSQL.Conn_SourceDB
ETL_DailyLoad.dtsxData FlowDeprecated ComponentWarning"Data Conversion" transform found - verify metadata against target column types.DFT_LoadOrders
ETL_DailyLoad.dtsxPackage ProtectionEncryption LevelPassedEncryptSensitiveWithUserKey - compatible.Package
ETL_DailyLoad.dtsxConfigurationPackage ParametersPassedAll parameters resolve to a supported data type.Package
ETL_DailyLoad.dtsxExecution32-bit Runtime RequirementPassedNo components require the 32-bit runtime.Package