have execute sqltask that quieres table and gets name of DTS, outputs to
parameter as rowset, then in activex script i go thru it to process.

sql task has output pararmeter rowset of gvDTSPackagesToRun

query:
select dts_package_name from Rerun_DTS_Package

result
----
XXX

get a rowset via
dim RS
set RS = CreateObject("ADODB.Recordset")
set RS = DTSGlobalVariables("gvDTSPackagesToRun").Value

however if i change query to

select dts_package_name from Rerun_DTS_Package
where Date_of_request > (SELECT LastStartTime FROM
dbo.NBT_LogBatch WHERE (ProcessName = 'DTS: NBT_OnDemand_ReRun_DTS') )

result
---
XXX

but rowset in activex script is empty


both queires give exact same result yet 2nd gives no output rowset

also tried
ISNULL(dts_package_name, 'ZZZZZ' ) dts_package_name
and get same results

In article <44bfa8b4$0$446$bb4e3ad8 (AT) newscene (DOT) com>, mistonl (AT) mail (DOT) com (Mistton) wrote:
doscoverd error of my ways. i save the laststarttime as a getdate(). when it
is compared to the date_request it will never match since getdate() is stored
as a binary not as a datetime. once i do a conversion to datetime then it
works