Bulk Insert Task

Question

Post reply

Bulk Insert Task

Scott Thornton-407727

SSCrazy

Points: 2271
More actions
June 30, 2008 at 8:55 pm

#129804

Hi,

I am trying do do a very simple import from a .csv file into a table on a 64 bit server (if that makes any difference).

When I Debug the package I get the following error:

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. The file "C:\stsbac.csv" does not exist.".

The file most certainly exists.

I have tried putting the file in different locations, and also tried a network share.

I have even re-booted to ensure that the file is not alrady opened by a different process.

Please help!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

KenpoDBA SSCrazy Eights Points: 9811 More actions · Answer 1

The first thing that comes to mind is maybe the file doesn't exist. It's possible that you're running the package on your workstation but the file is on the server.

It gets users (including me) all the time. You setup a file on the server to load and then you open that package from your local box and the file isn't found. That's because it always loads the package locally and runs it from there, meaning that it'll be looking at your local box and not the server for the file. And vice versa of course.

Now, I'm not saying this is exactly your problem, but it's a good place to start.

So are you positive that the file is where it should be on the box that the package is being run from?

Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant

Minion Maintenance is FREE:

Scott Thornton-407727 SSCrazy Points: 2271 More actions · Answer 2

Scott Thornton-407727

SSCrazy

Points: 2271

June 30, 2008 at 10:29 pm

#836437

Hello,

I am developng and debugging on my PC.

The package has not been deployed anywhere as yet.

The file exists on my PC.

tedo SSCrazy Points: 2229 More actions · Answer 3

tedo

SSCrazy

Points: 2229

June 30, 2008 at 11:00 pm

#836438

Maybe you should try bcp the file program itselft, are you sure the file is in the right format and you have the right headings for the columns.

Terry

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 4

Michael Earl-395764

SSC Guru

Points: 53873

July 1, 2008 at 5:36 am

#836564

The bcp task is the backwards one - the file location is from the perspective of the server that the task is executing against. So, the error message is indicating that the .csv file is not on the C drive of the server.

When using the bcp task, it is best to use a shared network folder.