How to reduce the detail level output by a DTEXEC job?
batch-file, ssis
Solution
You can use the flag `/Reporting` with level `N` (N stands for No reporting.) to prevent any status being reported to the command line console.
There are other levels like E for only Errors, W for only Warning. You can pick the choice of output that you would like to see on the console.
Refer MSDN to know more about dtexec Utility.
Syntax usage:
dtexec /f Package.dtsx /Reporting N
Alternative usage:
dtexec /f Package.dtsx /Rep N
Example:
- Created a simple package with one empty data flow task.
- Following screenshot shows when the package was executed using dtexec utility in the command line `without` the flag `/Reporting`. You can notice the status of data flow task is being displayed.
- Following screenshot shows when the package was executed using dtexec utility in the command line `with` the flag `/Reporting`. You can notice the status of data flow task is not being displayed.
Problem
Is there someway to reduce the detail level that is output when running a `DTEXEC` job ? e.g. in the cmd window I've got loads of ... ``` Progress: 2012-05-10 12:24:20.70 Source: Import Email_to Post Execute: 9% complete End Progress Progress: 2012-05-10 12:24:20.70 Source: Import Email_to Post Execute: 18% complete End Progress Progress: 2012-05-10 12:24:20.70 Source: Import Email_to Post Execute: 27% complete End Progress Progress: 2012-05-10 12:24:20.71 Source: Import Email_to Post Execute: 36% complete End Progress Progress: 2012-05-10 12:24:20.71 Source: Import Email_to Post Execute: 45% complete End Progress .... etc ... ```