We need to download a file from a secure website using either DTS or Visual basic.Any idea??Q1 We need to download a file from a secure website using either DTS or Visual basic.Any idea??
A1 A suggestion would be to gather additional specifications (available from the website host?); generally that should constrain the possibilities somewhat and make different options easier to evaluate in relation to the local environment and local security requirements.
For example: (Is this a rare or one time event, or an hourly, daily, or weekly event? May one use / choose among vpn, ssl methods, etc.? How large a file is to be transferred and what is to be done with it?)|||use OpenURL method, it can do https
Inet1.URL = "https://www.mysecuredserver.com/myfile.txt"
bValidate() = Inet1.OpenURL(Inet1.URL, icByteArray)
Open "c:\myfile.txt" For Binary Access Write As #1
Put #1, , bValidate()
;-)
jiri
