Ali Shah
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
regards