Hi SQLDEV,
According to your description, you are experiencing the issue "The directory "\\Cambosnapp01\Claims\Analytics\NICB " does not exist" when run the SSIS package in SSMS by using SQL Server Agent, right?
In your scenario, since you can run the package in SSDT manually. So as per my understanding, the issue can be caused by that the Services Account of your SQL Server Agent do not have the permission on that folder. To avoid this issue, you can set the folder permission for your SQL Server Agent account or change the services account to an account who have the corresponding permission. Please refer to the link below to see the details.
http://ift.tt/1BwjoXz
http://ift.tt/1tnwA0t
Regards,
Charlie Liao
If you have any feedback on our support, please click here.
Charlie Liao
TechNet Community Support
No comments:
Post a Comment