Hello People,
I would like to check that I have a valid connection between SQL Server and an AS 400 (200 miles away) before I execute a DTS Package, an ActiveX script would be great, and also how to terminte the package if the connection is down, I'll be executing the package every 10 mins.

Much obliged

You have asked the exact same question under a different subject line and a
different username. I have answered your other version

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Gary Spence" <Gary Spence (AT) discussions (DOT) microsoft.com> wrote

script would be great, and also how to terminte the package if the
connection is down, I'll be executing the package every 10 mins.