How to reduce the level of detail on a DTEXEC job?

Question

Is there a way to reduce the level of detail that is displayed during a DTEXEC job?

eg. in cmd window i have many ...

 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 ... 

Answer 1

You can use the /Reporting flag with level N ( N means No reports.) To prevent any status from being sent to the command line console.

There are other levels, such as E for error only, W for warning only. You can select the output option that you would like to see on the console.

Contact MSDN to learn more about the dtexec utility.

Using syntax:

 dtexec /f Package.dtsx /Reporting N 

Alternative use:

 dtexec /f Package.dtsx /Rep N 

Example:

• Created a simple package with one empty data flow task.
• The following screenshot shows when the package was launched using the dtexec utility on the command line without the /Reporting flag. You may notice that the status of the data flow task is displayed.

• The following screenshot shows when the package was launched using the dtexec utility on the / reporting flag with command line. You may notice that the status of the data flow task is not displayed.