"Darren Green" wrote:

> Jack wrote:
> > 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.
> >
> >
>
> You can use DTS, using the Data Flow task and the Write File load.
>
> Read File Transformation
> (http://www.sqldts.com/default.aspx?304)
>
>
> --
> Darren
> http://www.sqldts.com
> http://www.sqlis.com