Hi,

I've created a DTS package which opens a connection
(Microsoft OLE DB Provider) and save a .txt log file
(Text File(Destination)) using the Transform Data Task.
On success it supposed to execute a VB.NET application
(Execute Process Task) which is in the C:\ directory. So
with in the Execute Process Task Properties window I
point (WIN32 process to) to the applications' .exe file
(C:\TestApp\TestApp.exe). My issue is, when I run the
package from the Data Transformation Services it runs
perfect. The txt file is created and the application
executes. But when I schedule the package it seems to
fail. The txt file is created but the application does
not execute (The DTS package, database and application
are located on the same server). Does anyone have any
idea why the application does not execute when
scheduled.

Thanks in Advance.

In message <d47d01c48ac2$51a8ec10$a601280a (AT) phx (DOT) gbl>, Daniel B
<dberezniak (AT) repeatseat (DOT) com> writes
Try -

269074 - INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/?kbid=269074)

Make sure the VB.Net app has decent error handling and logging of any
failures, and also ensure it has no UI, or any silly things like message
boxes left over from development.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org