Ssis-957 - [work]

– SSIS‑957 is a regression introduced in the 15.0.2070.0 build that causes the runtime engine to throw a 0xC0202009 – “The data type of a column cannot be null” error when an expression contains a Unicode string literal. The issue is reproducible on both SQL Server 2022 and Azure‑SSIS Integration Runtime (IR) . Microsoft has released a hot‑fix (KB 5008870) and a permanent fix in the cumulative update (CU 8) for SQL 2022. Until you can apply the update, the recommended work‑around is to avoid the N'…' literal and use a variable or a CAST to DT_WSTR inside the expression.

SQL Server Integration Services (SSIS) provides a powerful expression language that lets you:

| Release | Fix Details | |---------|-------------| | (released 2024‑03‑12) | The expression compiler now correctly preserves the DT_WSTR metadata for Unicode literals. The regression test suite was expanded with the UnicodeLiteral scenario. | | Azure‑SSIS Integration Runtime | The same fix was back‑ported to the IR v2.2 runtime (released 2024‑04‑01). | | KB 5008870 (hot‑fix) | A targeted patch for the bug, applicable to SQL 2022 RTM and SQL 2022 SP1 . Installing the hot‑fix updates the Microsoft.SqlServer.Dts.Runtime assemblies to version 15.0.2070.20 where the issue is resolved. | ssis-957

<!-- Derived Column with Unicode literal --> <pipeline:component ID="Derived" classID="..." name="Derived Column" description="Test expression" localeID="1033"> <pipeline:inputs> <pipeline:input refId="Source" /> </pipeline:inputs> <pipeline:outputColumns> <pipeline:outputColumn name="IsUS" dataType="DT_BOOL" length="1" /> </pipeline:outputColumns> <pipeline:customProperties> <pipeline:customProperty name="DerivedColumnExpressions"> <pipeline:propertyValue> <![CDATA[ [IsUS] = @[User::Country] == N'US' ? (DT_BOOL)TRUE : (DT_BOOL)FALSE ]]> </pipeline:propertyValue> </pipeline:customProperty> </pipeline:customProperties> </pipeline:component> </pipeline:components> </pipeline:Pipeline> </DTS:ObjectData> </DTS:Executable> </DTS:Executables> </DTS:Package>

When the package executes, the first row causes the error even though the expression is syntactically correct. – SSIS‑957 is a regression introduced in the 15

| Symptom | Typical Message | Where you’ll see it | |---------|----------------|----------------------| | Package fails on the first row that reaches a data‑flow component using an expression with N'…' | Error: 0xC0202009 at Data Flow Task, Derived Column [123]: The data type of a column cannot be null. | SSIS Designer (Execution Results), console, Azure Data Factory monitor | | The same package runs fine on SQL 2019/2021 or after removing the N prefix | No error (or the same expression works with ‘…’ non‑Unicode) | — | | The error occurs even when the Unicode literal is not part of a variable (e.g., @[User::Country] == N'US' ) | Same as above | — | | The failure is reproducible on both on‑prem SSIS Catalog ( /SSISDB ) and Azure‑SSIS IR | Same error code and text | — |

If you would like to analyze this topic further, tell me if you want to explore the , the evolution of the S1 studio lineup , or trends in the Japanese entertainment industry . Until you can apply the update, the recommended

Observe the failure at with the following error: