How would you test if there is established connection to a data source and
then use this information
when continuing...?

If no connection abort operation....

A connection AFAIK is opened on demand in a package and usually closed on
completion.

What exactly are you trying to do ?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Trying to improve my errror handling.

Have the following package

Grandfather --> father --> son....

When executing this from sql server agent I schedule the grandfather
package.

This means I don'¨t get much info in SQL server agent .... in fact the other
day something was wrong in one of the son packages but in the sql server
agent then grandfather job
sad it was completed succesfully - but i took 3 minutes with no records
instead of the normal 50 minutes.

Was told that someone had put a lock on the tables that I tried to access -
perhaps it just my connections between the tasks that should be changed - it
should only continue
if some steps succeeded....that way I don't need to test anything... ?

But I still need to get the info to the user that the packages didn't
run....

llan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote