Deployed SSIS package has access denied to file directories and work fine in VS

Apostolu, Chris 0 Reputation points
2025-06-02T15:38:53.3733333+00:00

I’ve tested a couple of things out with different packages that have been deployed to SQL Server. I noticed that within the same package, I can have a script task which fails to connect to a file directory but I don’t have an issue with connecting a flat file data source task to the same directory. If I use a flat file destination task, that fails also. It sounds like something doesn’t have full permissions because the flat file source task just reads the file without issue. I run this in VS and there are no problems. when I check the logs of the deployed package it shows my id as the Executed As Name and the Caller Name. The network guys say that the ids being used have read/write access.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.