|
Home > Archive > MS SQL Server DTS > January 2006 > load postscripts into sql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
load postscripts into sql
|
|
|
| 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.
| |
| Darren Green 2006-01-27, 1:23 pm |
| 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
| |
|
|
|
|
|