Okay, I want to do something simple. I want to grab only those records from AD that have a non-NULL value (if it's not NULL, then it's a five digit number) in the employeeNumber attribute. So far, I can't find any way to do this. If I put this script in the transform for employeeNumber or in the Global Script under DTM_BuildSourceQuery:
IF Len(DTM.Source("employeeNumber")) <> 5 THEN
DTM.CancelRow()
ELSE
DTM.Result=DTM.Source("employeeNumber")
END IF
I get an error. In the transform, the script won't test right for the NULL case of employee number (but the transform script engine can't handle NULLs period, so I don't know what to do here). If I try it in the Global Script, it compiles, but errors out.
Related to this I see constant references to a "filter query" but I can't see anywhere in the GUI to put one in. Older versions of DTM would show you the overall script, and you could modify it to restrict to certain object classes in AD, but that feature seems to be gone in 3.x...
This is driving me nuts... any help would be appreciated.
-Bill