"Erland Sommarskog" wrote:

> Jack (J***@discussions.microsoft.com) writes:
> > 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.
>
> 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, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>