# SSIS package failures when calling API's

**URL:** <https://devforum.zoom.us/t/ssis-package-failures-when-calling-apis/58177>\
**Category:** API and Webhooks\
**Created:** [September 29, 2021, 7:52pm UTC](https://devforum.zoom.us/t/ssis-package-failures-when-calling-apis/58177 "2021-09-29T19:52:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbailey](https://avatars.discourse-cdn.com/v4/letter/d/50afbb/32.png) [@dbailey](https://devforum.zoom.us/u/dbailey)\
**Post date:** [September 29, 2021, 7:52pm UTC](https://devforum.zoom.us/t/ssis-package-failures-when-calling-apis/58177/1 "2021-09-29T19:52:18Z")

</div>

SSIS/Perl script failures

**Description**  
I’m accessing the Zoom API’s using a Perl script, and the script is executed from an SSIS package. The script has been failing with an exit code 10060, which I believe is related to a connection. The script is failing between 1 and 2 a.m. The job is scheduled for 1:00 a.m.

The SSIS package is exececuted from a SQL Server Agent job.

**Error**  
"“apReEYXKQZW7e2rSItJ15g==” “1632960000” “98214650543"” at “C:\sqladmin\dts\bin\perl”, The process exit code was “10060” while the expected was “0”.

**Which App Type (OAuth / Chatbot / JWT / Webhook)?**  
JWT

**Which Endpoint/s?**  
[https://api.zoom.us/v2/report/meetings/{InstanceID}/participants](https://api.zoom.us/v2/report/meetings/%7BInstanceID%7D/participants)

**How To Reproduce (If applicable)**  
Steps to reproduce the behavior:  
When Job runs

**Additional context**  
Are there times when the API is not available?

---

<div class="post-metadata">

**Author:** ![will.zoom](https://sea2.discourse-cdn.com/flex016/user_avatar/devforum.zoom.us/will.zoom/32/14417_2.png) [@will.zoom](https://devforum.zoom.us/u/will.zoom)\
**Post date:** [October 4, 2021, 2:54pm UTC](https://devforum.zoom.us/t/ssis-package-failures-when-calling-apis/58177/2 "2021-10-04T14:54:26Z")

</div>

Hi @dbailey,

This looks like it may be an environment specific error. Do you have any issues when you call this endpoint in Postman, using cURL from terminal, etc.?

Thanks,  
Will

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex016/uploads/zoomdeveloper/original/3X/6/1/614bdd549b610bbaa46ff934617683a02bdaa03c.png) [@system](https://devforum.zoom.us/u/system)\
**Post date:** [November 4, 2021, 12:54am UTC](https://devforum.zoom.us/t/ssis-package-failures-when-calling-apis/58177/3 "2021-11-04T00:54:43Z")

</div>

Closed on November 4, 2021, 12:54am UTC

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
