BULK INSERT PROBLEM

ZoroAstris · December 30th, 2004, 06:54 AM

I have a problem using the BULK INSERT statement in a script.
The script looks like
BULK INSERT xxxx from 'C:\TMP\yyyy.txt'
with (FieldTerminator = ' ') ...

My problem is that the ASCII file have to be placed on the server
folder c:\tmp.
I would like to run the script from the network (from a Workstation)
placing the ascii file in a folder not in server.
Is it possible ?

jemacc · December 30th, 2004, 10:44 AM

Do you mean before you place the file in the c:\temp it must exists?

and if it does not exists create it?

Jaime E. Maccou

jemacc · December 30th, 2004, 11:12 AM

you can simple create a batch file that copies files from your workstation to the server folders

Code:

rem copy files from your work station
copy \\<your workstationname>\c$\folder\\yyyy.txt \

keep in mind that the account you use must have permission to read/write to the server folder.

you can also use xp_cmdshell

Code:

USE master
EXEC xp_cmdshell 'copy c:\tmp\yyyy.txt \\server\folder\', 
   NO_OUTPUT

Jaime E. Maccou

greenash · January 3rd, 2005, 09:18 AM

A simple suggestion.
You can share the TMP folder on the Server and use the UNC path in the script as '\\ServerName\TMP\yyyy.txt'
Hope this helps.