Bulk Insert Task
-
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!
-
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/DBARantMinion Maintenance is FREE:
-
Hello,
I am developng and debugging on my PC.
The package has not been deployed anywhere as yet.
The file exists on my PC.
-
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
-
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.
-
Thankyou.
-
I've got a couple videos on BCP if you like...
http://midnightdba.itbookworm.com/index_files/Page380.html
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply