0

Requirement: We need to migrate SSIS/DTS package from SQL Server 2008 to another machine having SQL Server 2012 on it.

Steps performed so far: 1. First I exported the package from Source server to File System with ProtectionLevel as "Encrypt Sensitive Data with password" 2. Then I connected to Destination and imported the package after connecting to Integration Services on it. After that I created same job as it was in Source, providing DTSConfig File and checked Checkbox "Use 32 Bit Runtime" 3. After that I ran the job and it got failed with below error message.

Executed as user: XXXX. Microsoft (R) SQL Server Execute Package Utility Version 11.0.7001.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:39:55 PM Error: 2019-08-08 17:39:57.99 Code: 0xC004706F Source: ProcessFiles XXXXXX [141] Description: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully. End Error Error: 2019-08-08 17:39:57.99 Code: 0xC002F304 Source: MoveSourceFileToError File System Task Description: An error occurred with the following error message: "Could not find file '\XXXXX\XX\XXX\XXXX\XXXX.csv'.". End Error Error: 2019-08-08 17:39:58.01 Code: 0xC0047062 Source: ProcessFiles XXXX[141] Description: The script component includes no code. Edit the component to include code. End Error Error: 2019-08-08 17:39:58.03 Code: 0xC002F304 Source: XXXXXX File System Task Description: An error occurred with the following error message: "Could not find file '\XXXXX\XX\XXX\XXXX\XXXX.csv'.". End Error Error: 2019-08-08 17:39:58.04 Code: 0xC004706B Source: ProcessFiles SSIS.Pipeline Description: "XXXXX" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2019-08-08 17:39:58.04 Code: 0xC002F304 Source: MoveSourceFileToError File System Task Description: An error occurred with the following error message: "Could not find file '\XXXXX\XX\XXX\XXXX\XXXX.csv'.". End Error Error: 2019-08-08 17:39:58.06 Code: 0xC004700C Source: ProcessFiles SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2019-08-08 17:39:58.06 Code: 0xC002F304 Source: XXXXXX File System Task Description: An error occurred with the following error message: "Could not find file '\XXXXX\XX\XXX\XXXX\XXXX.csv'.". End Error Error: 2019-08-08 17:39:58.07 Code: 0xC0024107 Source: ProcessFiles Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:39:55 PM Finished: 5:39:58 PM Elapsed: 2.265 seconds. The package execution failed. The step failed.

Troubleshooting Steps: 1. I opened the package in SQL Server Data tools on destination server and got below error message:

error message while opening package in SSDT

  1. When opening the Script task and clicking on Edit Script button, getting below error message:

Edit Script Error message

  1. As per

https://social.msdn.microsoft.com/Forums/en-US/5049f594-2ab0-4a51-b2b1-32e62dd6e4c6/cannot-show-visual-studio-tools-for-applications-editor-visual-studio-2010?forum=isv

I first installed SSDT but after seeing this i uninstalled SSIS and SSDT both and then installed both together, but still getting same error message.

Am I missing something? Do I need to upgrade the package, then only it will work? If yes, then what is the process of upgrading package?

Please help me as I am stuck. Thanks in advance. :)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.