Error when deploying SSIS package in 2012


  • Hi,

    I am trying to deploy a SSIS package to 2012 version. But i am getting error as  below,

    TITLE: SQL Server Integration Services

    There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
    File name: 'Microsoft.VisualStudio.Tools.Applications, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
       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)

    There are 4 packages of same version,  i get this error only for 2 packages and other 2 am able to deploy successfully. Can someone tel mewhat would be the issue.

    the same package is successfully deployed from my colleague machine.


    Friday, March 28, 2014 6:51 PM


All replies