🧪 | Step | Action | Expected Result | |------|--------|-----------------| | 1 | Create a flat‑file source ( .csv ) containing Chinese characters and emojis, saved as UTF‑8. | File opens in Notepad++ with “UTF‑8” label. | | 2 | Drag a Data Flow Task → Flat File Source → OLE DB Destination (NVARCHAR(MAX) column). | No warning about code‑page conversion. | | 3 | Execute the package. | All Unicode characters appear unchanged in the destination table. | | 4 | Open the Progress Tab → confirm PreserveUnicode = True in the runtime log. | Log entry: Unicode preservation enabled – No truncation detected. |
Follow the principle of least privilege. Only grant SELECT , INSERT , UPDATE , DELETE as required. SSIS-927