|
Home > Archive > MS SQL Server Tools > January 2006 > load postscript files in SQL 2000
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 postscript files in SQL 2000
|
|
|
| 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.
| |
| Erland Sommarskog 2006-01-27, 8:24 pm |
| Jack (Jack@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, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
| |
|
| thank you for the feedback.
"Erland Sommarskog" wrote:
> Jack (Jack@discussions.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@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>
|
|
|
|
|