This is currently set to 0.  Isn't this the value to imply "unlimited"?

If so, I still get time-out messages using this method of querying a table.  The message...

[Microsoft][ODBC SQL Server...

Along the same line, what if you're in EM and you right-click on a table and select Open Table | Query?  How do you change the time-out setting here?

Thanks for the additional information -- I'll check out the Yukon forum.

I think we're on the same page. 

I also think that our latest replies got crossed in the mail. 

Right, I found that.  So, you're setting the global variable based on the results of the T-SQL Task, then...

T-SQL >>> Set global variable based on results >>> check value of...

Where (at what point) do you set your global variable?

From BOL...

DTSStepScriptResult

The DTSStepScriptResult constants specify return codes to be used from the Microsoft® ActiveX® scripts associated with package steps. They should not be returned from the scripts associated with...

Add an ActiveX Script which would check the results of the query in question.  Then use logic to test for the criteria you're wanting to stop execution...

If x Then

To jump-start my SQL Server 2000 library, I have just purchased #1 thru #4 & #6 all online (some new, some used) for a grand total of about $85.  Not too...

I did find the book by this site "The Best of SQLServerCentral.com 2002".  In addition to this book, I'm also considering books from the following list.  Can you recommend 2-3...

Can you use linked servers for this task?

When working with Access and SQL Server, we normally use Access as a sort of Front-End and SQL Server as the data store. Try Alamir's suggestion and use ODBC...

To assign someone to an existing role, you could use the following SQL...

GRANT SELECT ON

tablename

TO rolename

I don't know if there are duplicate rows in the resultset of the union of the logon and logon_archive tables, but you might want to use UNION ALL so that...

Another good resource for DTS besides this site (which is the best!!!) is http://www.sqldts.com/