Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
REPORT FORM and the DTS Package Scheduler in SQL Server
Message
From
26/07/2002 11:42:15
 
 
To
26/07/2002 03:59:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00682887
Message ID:
00683026
Views:
27
>Hi there
>
>I have a VFP6 program that contains a REPORT FORM ... NOCONSOLE TO FILE ...
>I built an .exe from this program and I am calling it in a DTS package.
>And it works fine as long as I manually execute the DTS package.
>But when I scheduled it it doesn't work anymore because of the REPORT FORM.
>I think the DTS package scheduler only likes processes that don't stop execution and somehow the REPORT FORM stops it.
>Does anyone know what I can do to have the process scheduled and still working?
>Thanks a lot.
>
>Kind regards,
>Severus

If you look at the package history details, what is the error message?

I would look into permissions to write the file, when you schedule the package it runs under a different security context that might not have permissions to the folder specified in the REPORT FORM command.

Another thing to look at are mapped drives. When the package runs scheduled mapped drives are not visible, you have to use UNC paths.
Previous
Reply
Map
View

Click here to load this message in the networking platform