I have an SSIS package to consume REST API GET request to extract Jira data into our SQL server, with a 3rd party tool called Zappysys.
I used basic authentication (username/password) in the HTTP connection manager for Jira authentication. The SSIS package works fine on my local machine using SSDT. But when the package is deployed to the SSIS server, and ran from SQL server agent job, the job fails. I keep getting a 403 Forbidden error message, please see attached error message.
I am very new to SQL server as well as HTTP requests. Much appreciated if anyone has any idea about what the issue is. More than happy to provide more info. 
