Problem Scenario:
I have used DTExecUI configuring and executing the package, it works fine. But when I copy the command, and execute the package with DTExec, I get the following error:
=========================
......
Error: 2015-05-13 08:26:27.53
Code: 0x00000003
Source: Script Task Script Task
Description: There was an exception while loading Script Task from XML: Syste
m.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStu
dio.Tools.Applications.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b
03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file spe
cified.
File name: 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0, Cu
lture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1a()
at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.DisposeVstaHelper()
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.MigrateVSTADenaliScrip
tProject(XmlElement elemProj, IDTSInfoEvents events)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement
elemProj, IDTSInfoEvents events)
.......
=========================
Solution:
Use the SQL Server 2012 Installation Disk, go to \redist\VSTA\runtime\x64, find and run VSTA_RT30.msi
