all groups > sql server connect > january 2006 >
You're in the

sql server connect

group:

load postscript file into sql


load postscript file into sql Jack
1/26/2006 11:31:02 PM
sql server connect:
We are having a website that generates postscript files when an order is
placed on it. These files are placed in a folder on the network.

I have been told to Load the postscript files into an existing sql database
and then delete the file from the folder.

If anyone has an idea on how to load the data from a postscript file into
SQL 2000 database, please give me an example/sample script. Also, how do I
delete the file after that.

My email is Jacktundra@hotmail.com if you need to email me.

RE: load postscript file into sql Sreejith G
2/3/2006 3:33:07 AM
Write winbatch execulatbles for the same...

Connect to server inside winbatch and load usiing bcp, or osql command,
after that write a function to delete it from taht folder.

Thanks,
Sree

[quoted text, click to view]
AddThis Social Bookmark Button