I am an accidental DBA trying to install existing SQL Server 2005 in a new environment with existing contents. I have done my googling on this but with little help.
We sometimes use Integration Services packages run straight from Execute Package Utility (dtexec) - so NOT from SQL Server Agent job or other application. Now I cannot get a SSIS package to execute at all, when trying to "Run package". The error is "You do not have permission to use bulk load statement." At this point, the package should bulk load data from a csv file to database table. The csv file location and format are specified in dtsConfig files. Other ETL packages without any "outside" csv files run just fine.
As you know, using SSIS this way requires authenticating with Windows credentials. SQL Server is installed on drive D. The csv files in question are situated on drive G on the same server. Any jobs or other SSIS packages have not caused any trouble.
This clearly is some kind of permission issue but what permissions should I give, to whom and where? Advice would be much appreciated.