i realize that i'm probably overlooking something quite simple but i'm
stumped.  we are using biztalk 2002 to process hipaa transactions.  we
drop the file into a certain directory, biztalk processes it, and we
grab the output from a different directory for processing.  what i've
been assigned to do, is automate this process through dts (basically,
i'm just using vbscript for this portion).  i should mention that i'm a
dts guy, NOT a biztalk guy.  my problem is that i cannot figure out how
to determine when the file is done processing.  the scripts that i've
set up will check the locks on the file and when the lock is removed,
it moves the file.  however, the locks seems to go on and off because
after the lock is off, the file gets moved, and behold, the 2nd half of
the output is then delivered to the folder.  i've been checking the
locks and only allowing the move after it hasn't been locked for x
amount of iterations.  not efficient and not reliable!  there must be
some way that biztalk  can tell me when it's DONE with the file.  i've
tried querying the cs_workq table but i see that it still processes
after that table is empty.  i don't really see any other tables that
look like what i need.  i've tried wmi scripts but couldn't seem to
find the right scipts.

so, after the long, rambling backstory, could someone PLEASE provide a
way i can be sure biztalk is done processing the file?  probably using
wmi or the database via vbscript.  thank you in advance!

heath

[ Post a follow-up to this message ]