2  

Change the reporting level to Errors and/or Warnings,
it's the Progress reporting that is annoying you.

将报告级别更改为错误和/或警告，使您烦恼的是进度报告。

Errors Only

dtexec /Reporting E /f "path\to\package\mypackage.dtsx" >> "path\to\log\logfile.log"

Warnings Only

dtexec /Reporting W /f "path\to\package\mypackage.dtsx" >> "path\to\log\logfile.log"

Errors and Warnings

dtexec /Reporting EW /f "path\to\package\mypackage.dtsx" >> "path\to\log\logfile.log"

E Errors are reported.
W Warnings are reported.

报告错误。W警告报告。

Reference :

https://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

https://technet.microsoft.com/en-us/library/ms162810(v = sql.105). aspx

If the /Reporting option is not specified then the default level is
E (errors), W (warnings), and P (progress).

如果没有指定/Reporting选项，则默认级别为E(错误)、W(警告)和P(进度)。

1  

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.

您可以使用第N级的标志/报告(N代表无报告)来防止向命令行控制台报告任何状态。

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.

还有其他的级别，比如E只针对错误，W只用于警告。您可以选择您希望在控制台看到的输出。

Learn more about dtexec Utility this MSDN article.

了解更多关于dtexec实用工具的这篇MSDN文章。

Syntax usage:

dtexec /f Package.dtsx /Reporting N

Alternative usage:

dtexec /f Package.dtsx /Rep N