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 (AT) hotmail (DOT) com if you need to email me.

Jack (Jack (AT) discussions (DOT) microsoft.com) writes:
Do you want to load the postscript file as-is? You say "load the data"
sounds like you are intend to somehow parse the file. If that is what
you are looking into, I think you would first have to talk to people
in some postscript newsgroup.

If you are looking to storing the postscript file as is in the database
that should probably be in a column of the type text or ntext. It's
difficult to give examples, since you did not mention in what
enviroment you are working in.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

thank you for the feedback.

"Erland Sommarskog" wrote: