 | |
load postscripts into sql
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
load postscripts into sql -
01-27-2006
, 01:30 AM
#2
| |||
| |||
|
|
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. |
Read File Transformation
(http://www.sqldts.com/default.aspx?304)
--
Darren
http://www.sqldts.com
http://www.sqlis.com
#3
| |||
| |||
|
|
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 (AT) hotmail (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.