dbTalk Databases Forums  

Local package does not write data into the database WHEN scheduled.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Local package does not write data into the database WHEN scheduled. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
LiliA
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.