I have a simple SSIS pipeline that gets data from a .csv file on a local computer and inputs it into a database on a remote SQL server. I have prepared a package in Visual Studio which works on execution and have deployed it to a Integration Service Catalog. When I attempt to manually execute the package in SSMS Catalog or on a schedule through SQL Server Agent, I am getting the following error:
Data Flow Task: Error: Cannot open the datafile "C:\Users\user\folder\data.csv"
I have verified that:
1.The package author corresponds to the account executing the package
2.The SQL server user has Full control and Modify permissions for the \folder and the .csv file
Most solutions online point to these two points, however I am still getting the same error