I have a SSIS script that validates directory's and files exists before the SA job continues. This task works on my local 2016 server, and our old 2008 production server but fails on our new 2019 server, which is a virtual server we lease through UNISYS. I believe this is a firewall issue. I am looking for a way to test the to see if this is a firewall issue. I came up with the TSQL script below but it always returns "No". Even when I run it on my local server or from our old server. I know they have assess. Why does this not work and how do find out why the new server running SSIS package returns Directory does not exist error. Thanks for any help in advance.
Declare @isExists INT
EXEC xp_fileExist '\\Domain\apps\GMSIMBTracing\History\IMB_VSAM_FILE.TXT' ,@isExists OUTPUT
SELECT CASE @isExists
WHEN 1 THEN 'Yes' ELSE 'No' END as isExists