Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2002-07-03 : 00:50:04
|
| hi,i need to read a log file which is created on a server .the log file is saved in an ftp account and save the contents in sql table ,is there any way to read files from FTP accounts through stored procedures.and how do i 'read' an .log file ???pl. help harsh. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-07-03 : 02:09:26
|
| ya i just read the article,but this will just download the file i have to store the contents into a table.thnxs,harsh. |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-07-03 : 02:54:39
|
| harsh,There is a DTS Task called "File Transfer Protocol Task".Use it in conjunction with a "Bulk Insert Task"DavidM"SQL-3 is an abomination.." |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-07-03 : 03:06:51
|
| thnxsi'll just go over it.thnxs againharsh. |
|
|
|
|
|
|
accessing an ftp server