sql server dts: 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

Haven't tried it but one option to try is using rasdial from
the command line. There is also a disconnect command.
http://technet2.microsoft.com/WindowsServer/en/library/68a62545-eb17-4ebb-9067-baa17c456fd61033.mspx?mfr=true

-Sue

On 29 Oct 2006 01:17:23 -0800, "Kayda" <blairjee@gmail.com>
[quoted text, click to view]