Avatar of Ali Shah
Ali Shah
Flag for United Kingdom of Great Britain and Northern Ireland asked on

SQL Job Error in SSIS Package

Hi guys,

I have created a job in SQL Server Agent. My SSIS project is deployed in SSISDB. I have got a wrapper package which is being executed by this job. Now the job fails and complains about the package BookingRevision.dtsx

When i run this package from my local it runs successfully but fails in the job. The only difference between this package and other successful packages within job is that this package is using a Data Conversion.

I am relatively new to SSIS so really unable to understand that why is this package not giving any error from local but when i run it from the server it comes up with the error message.

I have attached the error file
Report.docx
SSISMicrosoft SQL Server

Avatar of undefined
Last Comment
Ali Shah

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Nakul Vachhrajani

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Ali Shah

ASKER
Thanks a lot. Yes Server was low on resources. There was no way that we were going to upgrade the resources. So i split my wrapper package into multiple wrapper packages and especially those one containing high volume of data transfer and it works.

regards
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy