Dialing from DTS?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi:

I have a possible project to work on where I will have to
(unfortunately) pull data from multiple servers, each with it's own
dialup connection.

My question is, is it possible to dial a connection from within DTS,
and then hangup when the package is finished? If not, any good
recommendations on how to do this using DTS in combination with some
other technology? Basically, a scheduled package will run after
midnight and have to dialup each server individually. I already have
one package that loops through the various DSNs for different servers
(of this particular database), but all of this particular customer's
servers are all accessed through dialup.

I'm most likely going to have to use SQL 2000 here, not SSIS. But any
comment on any differences in SSIS would be welcome.

Thanks,
Kayda

.

Relevant Pages

  • Re: hotmail attachments
    ... > a song - 4.3mb ... connect to the Internet, but if you use dialup your connection is ... Hotmail's servers, although I very much doubt that Hotmail will let you ... Also, if you are sending it to someone who only has dialup, you'll ...
    (microsoft.public.windowsxp.general)
  • Re: Dialing from DTS?
    ... There is also a disconnect command. ... a scheduled package will run after ... midnight and have to dialup each server individually. ... one package that loops through the various DSNs for different servers ...
    (microsoft.public.sqlserver.dts)
  • Re: Ever heard of a mail server which blocks by type of IP address?
    ... servers to block connections from specific ip's. ... trying to forward mail to it against a list of dialup ip blocks. ... is this similar to blocking based on whether the headers in fact ...
    (microsoft.public.security)
  • trying to connect to rdp over vpn
    ... i have setup vpn and windows terminal server on W2k servers ... i dialup to the vpn get connected and can then connect to any of my 3 ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Question!
    ... > Just to make sure the client policy and the server policy and the package ... > Right click your package and update it. ... wait for the other servers to get the new policy ... >> "Roaming boundaries" tab have set the "include site boundaries within the ...
    (microsoft.public.sms.admin)