how lmit - control output of dtexec ?

Hi,

we have job that execute SSIS (s) using dtexec and save output(s) to file

Output of SSIS is 4 page long full of entries like

Validating: 0% ..ProgressProgress: .. Prepare for Execute: 100%

1. Can I limit output to show only success or failure ?
2. Can I redirect output of dtexec to be saved in msdb insted of showing after execution.

Thank you

Alex

Alex_UTL wrote:

1. Can I limit output to show only success or failure ?

dtexec has an option /Rep (or /Reporting) that lets you select the events you want reported.

/Rep[orting] Level[;EventGUIDOrName[;EventGUIDOrName[...]]
Level = N or V or any one or more of E, W, I, C, D, or P.

'/Reporting E' shows only errors, '/Reporting W' shows warnings, etc. I think success or failure is reported regardless of the option. Try the option N and see if that helps.

Check out Book online entry for dtexec utility.

Alex_UTL wrote:

2. Can I redirect output of dtexec to be saved in msdb insted of showing after execution.

I think this is better done in the package, but there is a '/Logger' command line option for dtexec which you can try.