Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
TechDevOps.com
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}



Text was truncated or one or more characters had no match in the target code page
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2016-09-07









Production Microsoft SQL Server Job running an Integration Services Package



SQL Job History Error Message:


Microsoft (R) SQL Server Execute Package Utility Version 12.0.4100.1 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.

"Text was truncated or one or more characters had no match in the target code page.".



Solution:


Step 1: Backup the current Production Environment .dtsx file & any related configuration files


Step 2: Copy the Production .dtsx file & any related configuration files to a local Development Environment


Step 3: Open the .dtsx file, using Microsoft Visual Studio 2008, in the Development Environment. (Setup the same file/folder
structure as Production to avoid any issues with that.)


You will notice the below warning/error messages. Follow through the the Metadata update:


Image #1: Data Flow - External Columns out of Synch warning message




Image #2: OLE DB Source - Truncation warning message




Image #3: OLE DB Source - Metadata warning message & Update Metadata. Select "Yes".





Step 4: Save the file in Microsoft Visual Studio 2008. At this point the .dtsx file is updated & ready for promotion to
Production


Step 5: Once your Change Management process is approved, promote the saved .dtsx file to the Production Server and re-run the
SQL Job.


That's it!