[ ] Verify SSIS version – apply CU with KB‑xxxxx if < 2024‑03. [ ] Change destination columns to NVARCHAR where feasible. [ ] If VARCHAR must remain, add a Data Conversion component with explicit code page (1252). [ ] Add a Script Component to log any Unicode→ANSI loss. [ ] Enable package logging (OnError, OnWarning) and monitor catalog.operation_messages. [ ] Run a validation job on a sample payload containing characters like é, ß, 汉. [ ] Document any rows that get truncated and decide on business rules (drop/replace).