I am trying to create a bulk insert task in SQL Server 2005 (MS visual studio 2005).
I create the package fine but when I execute it I get the following error:
[Bulk Insert Task] Error: An error occurred with the following error message: "Cannot bulk load because the file "C:\data\massaged.csv" could not be opened. Operating system error code 1346(Either a required impersonation level was not provided, or the provided impersonation level is invalid.).".
I have my database conection set for Windows auth and I can login to the SQL Server ok.
I have added my windows login to the C: drive with full control.
I tried running the bulk insert query from the following with same error.
a) SQLCmd and get the same error.
b) Studio manager
How do I check which login is being used to run the task and which to give access too. (running on Windows server 2003 standard sp2
I can open the .csv file and save changes to it ok so why can't I open it from the