SSIS package is failing in SQL agent job with webserviceTaskException: Service Description cannot be null

Hi All

we are using webservice task in our ssis package and the package is successful in SSDT . when we created SQL job using that package it is failing with  webserviceTaskException: Service Description cannot be null.

we have given access to web service for ssis proxy account  and have access on wsdl file folder  and given access to temp folder .

what would be the reason for the failure?

March 30th, 2015 5:28am

Hi Surendra,

what is the error message in full?

Did you try to run in SOPAUI with this account?

Free Windows Admin Tool Kit Click here and download it now
March 30th, 2015 9:40am

Hi Surenda,

As per my understanding, the error message is too general. In order to troubleshoot this issue, we should view the detail error message about this job. For more details, please see:
Troubleshooting Jobs
SQL Server Agent Error Log

Besides, since when you call a Microsoft SQL Server Integration Services (SSIS) package outside a SQL Server Agent job step, the SSIS package runs successfully. However, if you do not modify the SSIS package, then execute it via SQL Server Agent job step, it fails. The scenario always related to the user account that is used to run the package under SQL Server Agent. Please also verify that the account has access to the Web site or to the Web Service Description Language (WSDL) file for HTTP connection manager.

References:
SSIS package does not run when called from a SQL Server Agent job step
Example using Web Services with SQL Server Integration Services

Thanks,
Katherine Xiong

If you have any feedback on our support, please click here.
March 31st, 2015 3:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics