Sunday, March 25, 2012

BULK INSERT using Exisiting Folder

I am getting the following error when trying to point a Bulk Insert Connection Manager to an existing folder (rather than a file). Anyone else having this problem or know what i am doing
wrong? I find it interesting that is says file (below) when i told the connection manager to point to the folder. Thanks in advance.

"Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "Cannot bulk load because the file "c:\Folder\" could not be opened. Operating system error code 5(Access is denied.).".
Task failed: Bulk Insert Task"

James

Bulk Insert Task uses FILE connections that point to a file wich contains data that you want to be loaded using BULK INSERT statement.

Is there a reason you want to make the file connection point to a folder instead of a file?

Thanks,
Ovidiu

No comments:

Post a Comment