all groups > sql server programming > may 2005 >
You're in the

sql server programming

group:

Read a remote web file and parse it


Re: Read a remote web file and parse it John Bell
5/1/2005 12:00:00 AM
sql server programming:
Hi

Can you FTP the file? In which case you could use the DTS "File Transfer
Protocol" task to do this although if you used FTP.EXE from the "Execute
Process" or a xp_cmdshell call in a "Execute SQL" task" you may have more
control.


John

[quoted text, click to view]

Read a remote web file and parse it Andrea Moro
5/1/2005 1:56:17 PM
As subject, I need to read a remote web file, csv or xml isn't important,
from a t-sql sp scheduled in a job.

I don't know how to write the remote read steps. Any helps?

Andrea

AddThis Social Bookmark Button