RE: Bulk Insert Error Message

[allyne]

Hi Everyone,

I'm very new to all this and I am trying to import many .iff files into a table in a database that I remote into. I have a connection called BulkFile that connects to the folder where these files are sitting and I have a connection to the database (SQL)and table. When I execute the Bulk Insert Task I get the following error message. The "\\Admint\Responses" is the folder where the .iff files reside (BulkFile Connection).

SSIS package "Package.dtsx" starting.
Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot bulk load because the file "\\Admint\Responses" could not be opened. Operating system error code 5(Access is denied.).".

Task failed: Bulk Insert Task
SSIS package "Package.dtsx" finished: Success.

I believe I have all permissions needed. Any Idea what this error message means.

Thanks for your help!

 

[cmartin75]

If you're using sql server authentication to connect the database, the MSSQL Server service account must have read access to the file.

Microsoft recommends that if you're using windows authentication and still having problems (on osql or sqlcmd), trying to change to sql server authentication

http://msdn.microsoft.com/en-us/library/ms188365.aspx

(Security account delegation section)

But I had the same problem, and all of this didn't solve the problem. I finally copied the files on the local file system of the server and the BULK INSERTS worked.

 

[allyne]

Hello,

Thanks for your quick response. I tried all your suggestion but none worked. I copied the folder with the files onto the local file system of the server and if I just ask it to copy one particular file it works but if I ask it to copy all files in the folder I get the same error message.

Any suggestions?

Thanks for all your help.