BULK INSERT Error

[Aidy680]

I'm trying to load a .csv file into my SQL 2005 table but get the following error:

"Cannot bulk load. The file "\\server\directory\filename.txt" does not exist."

The file clearly does exist. Does the file have to be on the same SQL server box? Surely this cant be!

Is there a better way of doing this?

Thanks.

 

[bborissov]

Maybe the user who run this insert has no rights over that folder?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Aidy680]

I'm running it Borislav. Trying to get permissions assigned will be a lot of hassle.

I believe I can use SSIS. Not even sure how you launch it tho...!!

Thanks.

 

[Aidy680]

By way of follow up I ended up using the FileSystemObject and the OpenTextFile command to grab the file.

I then used a combination of 'Mid' and 'InStr' to seperate out the data within each record and assigned each to variables.

The variables were then passed to a SQL proc which inserted them into the table.

 

[Emtucifor]

ewww!

How about just copying the file locally to the SQL Server, then you'll be much more likely able to bulk insert the data since you won't be dealing with network permissions at all.