Re: Check connection to db
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/23/04
- Next message: Allan Mitchell: "Re: Check Connection"
- Previous message: Gary Spence: "Check Connection"
- In reply to: YRAG1: "Check connection to db"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 10:31:34 +0100
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@discussions.microsoft.com> wrote in message news:7F9DF4C0-7508-481D-B7F7-B906D329E036@microsoft.com... > 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. > >
- Next message: Allan Mitchell: "Re: Check Connection"
- Previous message: Gary Spence: "Check Connection"
- In reply to: YRAG1: "Check connection to db"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
