SQL SERVER Agent fail to run job - Update Extract Variable into Table

Ali Muhammad Nizamani 1 Reputation point
2021-09-29T04:11:11.7+00:00

I have developed two SSIS package under one solution in SSDT;

a. one without variable and
b. one with variable

Both the pacakages are working fine on development environment.

Then, deployed both the packages from VS SSDT to SQL SERVER
Integration Services Catalogs. Run both the packages, executes it
successfully.

Lastly, create job on SQL SERVER AGENT of both packages.
Job without package variable runs successfully but the job
having package variable didnt run successfully. Attached
error screen shot.

136132-error-message.png136141-error-message.png136099-integration-services-catalogs-deployment.png136038-package-variablesettings.png136124-sql-server-agent-job.png136030-variable.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2021-09-29T08:33:28.877+00:00

    Hi @Ali Muhammad Nizamani ，

    A truncation occurred during evaluation of the expression

    This error message usually indicates that the length of the expression is not enough.

    Try to change the expression for a try. Don't forget to redeploy the package.

    Check a similar thread here.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.
    Hot issues October

    0 comments