 | |
saving .txt file
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
saving .txt file -
07-07-2003
, 03:07 PM
#2
| |||
| |||
|
|
Hi , I have created a DTS package in SQL server 2000 which will write the contents of the table data to a text file. When the Job is invoked it creates the .txt file and saves it on the above server.It works fine for now If i decide to save the .txt file on some other server how should i do that ? Thanks for help Raka. |
#3
| |||
| |||
|
|
-----Original Message----- To access another machine from that on which DTS is executing you can use a UNC path (\\Machine\Share\File.txt). Or Run the package on the same machine as where you want the file. -- Darren Green http://www.sqldts.com "Raka" <rational_ed (AT) yahoo (DOT) com> wrote in message news:027701c344c3$698c74f0$a501280a (AT) phx (DOT) gbl... Hi , I have created a DTS package in SQL server 2000 which will write the contents of the table data to a text file. When the Job is invoked it creates the .txt file and saves it on the above server.It works fine for now If i decide to save the .txt file on some other server how should i do that ? Thanks for help Raka. . |
#4
| |||
| |||
|
|
-----Original Message----- To access another machine from that on which DTS is executing you can use a UNC path (\\Machine\Share\File.txt). Or Run the package on the same machine as where you want the file. -- Darren Green http://www.sqldts.com "Raka" <rational_ed (AT) yahoo (DOT) com> wrote in message news:027701c344c3$698c74f0$a501280a (AT) phx (DOT) gbl... Hi , I have created a DTS package in SQL server 2000 which will write the contents of the table data to a text file. When the Job is invoked it creates the .txt file and saves it on the above server.It works fine for now If i decide to save the .txt file on some other server how should i do that ? Thanks for help Raka. . |
#5
| |||
| |||
|
|
\\testserv\Bi$\SAP\inventory_onhand.txt where testserv is the server name and bi is share name. Did i write it correctly? -----Original Message----- To access another machine from that on which DTS is executing you can use a UNC path (\\Machine\Share\File.txt). Or Run the package on the same machine as where you want the file. -- Darren Green http://www.sqldts.com "Raka" <rational_ed (AT) yahoo (DOT) com> wrote in message news:027701c344c3$698c74f0$a501280a (AT) phx (DOT) gbl... Hi , I have created a DTS package in SQL server 2000 which will write the contents of the table data to a text file. When the Job is invoked it creates the .txt file and saves it on the above server.It works fine for now If i decide to save the .txt file on some other server how should i do that ? Thanks for help Raka. . |
|
« 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.