sql-server - 最近的 Windows 更新后，使用 dtexec 的批处理脚本不会成功

Question

上周五，我的 PC 进行了大约 2 个月的更新。现在我无法使用批处理脚本启动 SSIS。尝试使用 gacutil.exe 将 Microsoft.sqlserver.manageddts.dll 添加到 C:\Windows\System32 目录。它显示为 11.0.5058.0 版本。下面批处理的读数。

Started:  3:43:52 PM
Info: 2017-05-19 15:43:52.75
   Code: 0x40019316
   Source:  Package Format Migration Module
   Description: The provider name for the connection manager "<Instance Name>" has been changed from "SQLNCLI10.1" to "SQLNCLI11".
End Info
Info: 2017-05-19 15:43:52.76
   Code: 0x40016019
   Source:  
   Description: The package format was migrated from version 3 to version 6. It must be saved to retain migration changes.
End Info
Warning: 2017-05-19 15:43:54.95
   Code: 0x00000000
   Source: Newest File Script Newest File Script
   Description: Found SQL Server Integration Services 2008 Script Task "ST_02497875f0894cd2bcce80dd7c3dcXXXX" that requires migration!
End Warning
Error: 2017-05-19 15:43:54.97
   Code: 0x00000003
   Source: Newest File Script Newest File Script
   Description: There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.VisualStudio.Tools.Applications, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d5XXXX'
   at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1b()
   at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.Run(Action action)
   at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.CleanUp()
   at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.DisposeVstaHelper()
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.MigrateVSTA21ScriptProject(XmlElement elemProj, IDTSInfoEvents events)
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj, IDTSInfoEvents events)

=== Pre-bind state information ===
LOG: DisplayName = Microsoft.VisualStudio.Tools.Applications, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d5XXXX
 (Fully-specified)
LOG: Appbase = file:///C:/Program Files (x86)/Microsoft SQL Server/110/DTS/Binn/
LOG: Initial PrivatePath = NULL
Calling assembly : Microsoft.SqlServer.IntegrationServices.VSTA.VSTA11, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080XXXX.
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe.Config
LOG: Using host configuration file: 
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v4.0.30319\config\machine.config.
LOG: Post-policy reference: Microsoft.VisualStudio.Tools.Applications, Version=11.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
LOG: The same bind was seen before, and was failed with hr = 0x80070002.
End Error
Info: 2017-05-19 15:43:55.03
   Code: 0x4001F300
   Source: SPDlabel 
   Description: Succeeded in upgrading the package.
End Info
Info: 2017-05-19 15:43:55.04
   Code: 0x4004300A
   Source: Export TXT file SSIS.Pipeline
   Description: Validation phase is beginning.
End Info

Answer 1

看起来您安装了一些更高版本的工具，这些工具可能已添加到您的路径中。

它正在尝试即时升级您的软件包，但失败了。

SQL 2008 的 dtexec.exe 将位于如下位置:

C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn

尝试显式运行那个。