question

AliMuhammadNizamani-8697 avatar image
0 Votes"
AliMuhammadNizamani-8697 asked Zoehui-MSFT answered

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

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-transact-sqlsql-server-integration-servicessql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @AliMuhammadNizamani-8697

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.