SSIS Script Component failing from Sql Agent Job

MSBI_Developer_1990 41 Reputation points
2022-04-12T09:51:01.767+00:00

Hi Folks,

I have ssis packge in that i have script task which creating multiple rows . i have copied package from another server. it is excuting fine visual studio 2019. As per my requirement i am sechudleing the package through Sql Sever Agent Jobs. Now its failing to due to some reansons.
its executed fine in previous server Jobs.

Thanks in advance

Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright (C) 2019 Microsoft. All rights reserved. Started: 6:36:44 AM Error: 2022-04-12 06:42:43.98 Code: 0xC0047062 Source: DTF_FillHelpGLRegister DTF_FillHelpGLRegister (Create multiple rows for GL Register [2]) Description: Failed to migrate scripts contained in the package to the VSTA 15.0 format. Move the scripts to a new Script Component. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 6:36:44 AM Finished: 6:42:44 AM Elapsed: 360 seconds. The package execution failed. The step failed.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,482 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,426 Reputation points
    2022-04-13T01:50:28.673+00:00

    Hi @MSBI_Developer_1990 ,

    Description: Failed to migrate scripts contained in the package to the VSTA 15.0 format. Move the scripts to a new Script Component.

    It seems the issue is related with the version.

    What's the previous SQL Server version and what the new version for the new server?

    Right click project > Properties > Configuration Properties > General > TargetServerVersion - Update to SQL Server Your version > Redeploy.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.