ssis - DTEXEC SQL Server 2012 30 秒后超时

Question

在 SQL Server 2012 上运行以下命令时:

dtexec /isserver "\My Folder\My Package.dtsx" /X86 /SERVER "." /REPORTING V /Par "$ServerOption::SYNCHRONIZED (Boolean)";True

我们每次都在 30 秒后收到以下错误:

Failed to execute IS server package because of error 0x80131904. Server: ., Package path: \My Folder\My Package.dtsx, Environment reference Id: NULL.
Description: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Source: .Net SqlClient Data Provider
Started:  1:57:04 PM
Finished: 1:57:35 PM
Elapsed:  30.311 seconds

Answer 1

"SYNCHRONIZED" 和"(Boolean)" 之间有一个额外的空格。删除这个额外的空间解决了错误。错误信息并没有指出这个问题，所以我们通过几个小时的反复试验来了解。该命令应为:

dtexec /isserver "\My Folder\My Package.dtsx" /X86 /SERVER "." /REPORTING V /Par "$ServerOption::SYNCHRONIZED(Boolean)";True

而且我们不再看到超时错误。