Making the world a better place by helping people understand their data.

SSIS Error: The component metadata is out of sync with the compiled script

Ran into this error when using a script task in SSIS.
The package ran fine on my machine, however once deployed to the dev server and run via job the following output was logged:

Log Job History (<job name>)
Message
Executed as user: <service account>.
Microsoft (R) SQL Server Execute Package Utility Version 12.0.5000.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.
Started: 8:44:58 AM Error: 2017-04-19 08:44:58.54 Code: 0xC0047062 Source: DFT – <data flow task> <script task inside DFT> [88] Description: The component metadata is out of sync with the compiled script. Recompile the script using the Script Component Editor.
End Error
Error: 2017-04-19 08:44:58.54 Code: 0xC004706B Source: DFT -<data flow task>
SSIS.Pipeline Description: “<script task inside DFT>” failed validation and returned validation status “VS_ISBROKEN”.
End Error
Error: 2017-04-19 08:44:58.54 Code: 0xC004700C Source: DFT – <data flow task> SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-04-19 08:44:58.54 Code: 0xC0024107 Source: DFT – <data flow task>
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).

 

Fix:

Open package, open script task, save (with no changes) then close and rerun package.

If this does not work, open package on the server and make the same changes, run package.



Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.