I use the following code in an activeX script following a select statement
if rs.bof or rs.eof then noOrders = true
if noOrders then
Main = DTSTaskExecResult_Success
if not noOrders then.... etc
My problem is that I'd like to add in another select statement further down the script and i don't want to have the message that it's been a success if the first query returns has an eof/bof....
Anyone think of a way around it?