We have several scheduled DTS packages on SQL Server 2000 sp3 moving data
from an accounting package. The transforms occasionaly hang up and the
problem may go unnoticed, is there a way to timeout a transform or any other
way of detecting this situation?

Julian Bowker
Marble Steps Systems

There is a Connect Timeout property on the SQL Server connection

--



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


"Julian Bowker" <julian.bowker (AT) removethis (DOT) marblesteps.com> wrote