Ssis Job Fails - Access Denied To Flat File

I have created an SSIS package that reads a csv file from a network shared drive and imports the data into our table. The package works fine in the Visual studio. I imported the pa

Solution 1:

When SSIS packages are executed from SQL Server they access File System using the SQL Server Service Account NT SERVICE\MSSQL$<Instance Name>(Where <Instance Name> should be replaced by the installed instance name).

Try running using a proxy account that has read/write permissions. Also, the service account must have these permissions on the data sources:

SQL Server Serivce account Permissions:

• Configure File System Permissions for Database Engine Access

Setting proxy account:

• Running a SSIS Package from SQL Server Agent Using a Proxy Account
• Create a SQL Server Agent Proxy