I am working on task that involves using Dev server to fetch ADO directory user information. I am connecting through SQL script i Script task and passing my User authentication. This is working fine locally. When I deploy the code to SSIS server using SSIS Catalog and ran in SSIS server using SSISuserProxy account ,it does not return any values in my SQL table but it does locally when I run in VS 2015 or SSMS via connecting through Linked server.
I am facing this issue past two weeks but not able to resolve on my own. I want to know if this is issue related to network or authentication.