I am new to SQL 2014 and I am bumping into issues with SSIS packages. I have a package that reads an Excel file and imports the data into a table. It runs fine on my laptop but fails to validate/run on the server due to permissions issues. The problem is... I cannot figure out the security context that the packages use on the server.
Is there a way to specify what user the packages run/validate under? Is this configurable or not? Is it different for the Validation and for running the packages on SQL Agent? Also is it possible to edit packages via SQL Mgmt Studio on the server? Right now I am using Visual Studio on my laptop and then publish them.