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!
|
|
|
|
|
|