Post reply

Connecting to VPN from SQL

  • November 13, 2003 at 3:09 pm

    #65734

    We need to automatically initiate a VPN connection to access and download data from a remote server to our server. A DTS package is scheduled to run on our server that processes this data. Is there a way to initiate this connection from SQL prior to the execution of the package and terminate it once it completes. Is there anyway to schedule the initiation of a vpn connection ?

  • November 14, 2003 at 2:10 am

    #482000

    You Could try adding an Execute Process Task to the start of your Package that calls the VPN Executable. However if your VPN software is anything like ours and requires a username and password then this may cause you problems unless you can pass these as parameters on the command line.

    Not sure how you would shut the connection down at the end though.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply