Local package does not write data into the database WHEN scheduled. -
11-28-2005
, 07:00 PM
Hello everyone,
I use SQL2000.
I creaded a local package that uses an ActiveX VB script to read data
from a XML file and put it into a table in the database.
This local package runs fine - updates correctly the table - when
manually executed (when I click the Execute Package popup menu).
I scheduled the package to run every hour.
The job created to run this package runs indeed everyhour and finishes
"successfull".
However if I check the table that needs to be update with the data from
the XML file I see that the table is not updated.
Please help.
Thanks,
LiliA |