Can't access a network share when executing a

Question

I'm currently having an issue where I can execute a package perfectly fine from SQL Server Data Tools but get the following error when trying to execute from within the SSIS Catalog:

File System Task:Error: An error occurred with the following error message: "Access to the path '\xxxxxxxx\xxxx\' is denied.". "

I'm logging in to SSMS and SSDT using the same log in details and was under the impression that when executing from the SSIS Catalog the credentials supplied when logging in to SSMS were used?

Just for clarity, I'm talking about executing directly from the menu in SSMS:

[]

Answer 1

It sounds like you don't have Kerberos configured on your SQL Server (double hop issue).

Here is the issue logged with MS which has been fixed now. https://connect.microsoft.com/SQLServer/feedback/details/767088/with-the-new-ability-to-execute-ssis-packages-from-tsql-kerberos-delegation-should-be-supported

Here is a great blog post on the details of this: http://www.sqlscientist.com/2014/01/setup-kerberos-authentication-for-sql.html

Once this is configured, you should be able to remotely kick off the job using a Stored Procedure, or SSMS on your local machine. It will pass your credentials if it is configured correctly, of course you have to make sure you have the proper permissions to access the network resource.