> I am using an xp_cmdshell sp to start a C# app. This app downloads
> data files and imports them into DB. It has a logging functionality
> built-in and when executed from the command line or WE, it records
> it's progress into a log TXT file. But when executed via xp_cmdshell,
> it doesn't write into its log file.
>
> Is it possible to enable it to write into a log file with xp_cmdshell?
> Should I be using a different extended sp to accomplish that?

<narine.kostandyan@prurealty.com> wrote:

>
>
>Thank you for replying, Erland.
>C# app works fine, we've had it running as a scheduled task for a while.
>The problem is after this app runs successsfully we need to execute a
>DTS package. Until now it's been running as two independent processes.
>DTS is scheduled to run a little after the app. I wanted to create a
>stored procedure that will execute an app and on success execute DTS
>package.
>This will not only ensure that DTS will run on success but also will
>require only one job scheduled.
>However, we do need to look at the C# app logs to understand errors
>better.
>Another alternative would be to write a VB script that will execute the
>app then use dtsrun utility to execute the package.
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>Don't just participate in USENET...get rewarded for it!