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?)