Menu

#7 Add ability to launch a process for each specific report

open
nobody
5
2005-08-11
2005-08-11
Brian
No

Add the ability to launch a subordinate task for each
type of report received.

Example: Execute a command after receiving a orders
report.

Specifics: The ability to execute a command complete
with fields would allow for better integration with AMTU.

We use DTSRun to launch MS DTS packages to import
or export data. We currently schedule these in such a
manner as to catch any applicable Amazon file.

The downside is that this is a less then ideal method of
catching a file.

Under certain circumstances files can be lost.

Because the incoming file name isn't known, a script
was written to rename the file and remove the old ones.
This script standardizes the incoming order reports so
that they can be accessed by a DTS package.

The action to take should be specified in the
configuration.

I estimate this to be a moderate difficulty project
requiring modification of the code involved in writing the
file to handle the event of a command line branch.

Discussion


Log in to post a comment.