This content has been marked as final. Show 2 replies
I set up a a supporting database task in Publisher that calls a stored procedure which does a bulk upload from a text file exported by QlikView. I followed the tips in Simple DB-Command Task in QVS/QV-Publisher 9 SR1?? and the procedure gets started, but when it comes to the point where it accesses the file, it throws 'Cannot bulk load because the file xxxxx could not be opened. Operating system error code 5(Access is denied.).' I am using a SQL Server account in the connection string and gave read+execute rights to the service account running SQL Server. I used the UNC notation in the filepath.
My environment is: QV 11 SR12, SQl Server 2008 R2.