Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  DTS import Condition

Author  Topic  jyeast Starting Member 2 Posts Posted - 2001-05-15 : 02:02:07 I am running a DTS package via SQLServerAgent. How can I check if an odbc datasource (on another machine) is available or not? In my package I drop and recreate the table first and then it goes to get the data... and of course if the datasource isn't there (other computer rebooting or something) I won't have any data until SQLServerAgent runs it again. Any suggestions would be much appreciated. Thanks. Jason