Hello People,
Can any one tell me how to check if the connection between SQLServer and an AS400 (200 miles away) is enabled using a DTS Package, I want to make sure the connection is there before I execute the package, an ActiveX script would be great, also how can I exit from a DTS package if the connection is lost, I intend to execute the package every ten minutes.
Very much obliged to any suggestions that are submitted.

The usual way would be to execute a dummy query against the server. What
you get back will determine the availability. If the connection is lost
during package execution then the associated task will fail and you can set
the package to fail on first error

--

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

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


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

sure the connection is there before I execute the package, an ActiveX script
would be great, also how can I exit from a DTS package if the connection is
lost, I intend to execute the package every ten minutes.