Visual Studio Business Intelligence

Category: sql server migration

Question

Mad_Don on Thu, 04 Sep 2014 23:36:13


We are planning and testing as we would love to move our SQL Server from 2008 to 2012.

I have restored a data base on the new server but there are some installation instructions for this one particular database that we use which requires some changes to be made using Business Intelligence Studio which I have installed on the new server using the SQL Media.

Now when I first open the project, it requires the database to be upgraded but I keep getting this error and I have been battling for some time now.

Please can someone try and point me in the right direction?

I am not a developer but I can understand a few things.

I have copied the error here and looking forward to some help on this if anyone can :-)

The Upgrade had Errors

- Upgrading package DataWarehouseUpdate.dtsx (Error)
    Messages
    * Information 0x40019316: : The provider name for the connection manager "Analysis Services" has been changed from "MSOLAP.3" to "MSOLAP.4".
    * Information 0x40019316: : The provider name for the connection manager "DataDB" has been changed from "SQLNCLI.1" to "SQLNCLI10".
    * Information 0x40019316: : The provider name for the connection manager "DSSDB" has been changed from "SQLNCLI.1" to "SQLNCLI10".
    * Information 0x40019316: : The provider name for the connection manager "Analysis Services" has been changed from "MSOLAP.4" to "MSOLAP.5".
    * Information 0x40019316: : The provider name for the connection manager "DataDB" has been changed from "SQLNCLI10" to "SQLNCLI11".
    * Information 0x40019316: : The provider name for the connection manager "DSSDB" has been changed from "SQLNCLI10" to "SQLNCLI11".
    
    * Information 0x40016019: : The package format was migrated from version 2 to version 6. It must be saved to retain migration changes.
       
    * Warning: Populate Database Variables: Found SQL Server Integration Services 2005 Script Task "ScriptTask_deb7168d821242ef8bb6e28fb0b1f257" that requires migration!
    
    * Error 0x3: Populate Database Variables: There was an exception while loading Script Task from XML: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications.Core, Version=10.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.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
       at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__1a()
       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.MigrateVSAScriptTask(XmlElement elemProj, IDTSInfoEvents events)
       at Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask.LoadFromXML(XmlElement elemProj, IDTSInfoEvents events)
    
    Assembly manager loaded from:  C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll
    Running under executable  C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe
    --- A detailed error log follows.

    === Pre-bind state information ===
    LOG: DisplayName = Microsoft.VisualStudio.Tools.Applications.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
 (Fully-specified)
    LOG: Appbase = file:///C:/Program Files (x86)/Microsoft Visual Studio 10.0/Common7/IDE/
    LOG: Initial PrivatePath = NULL
    Calling assembly : Microsoft.SqlServer.IntegrationServices.VSTA, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91.
    ===
    LOG: This bind starts in default load context.
    LOG: Using application configuration file: C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.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.Core, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
    LOG: The same bind was seen before, and was failed with hr = 0x80070002.
    
        * Error 0xc001f429: Package Upgrade: The loading of the package DataWarehouseUpdate.dtsx has failed.
    




Replies

Ivan Donev [MSFT] on Sat, 06 Sep 2014 17:26:52


Hello,

There is a similar connect item filed. Have you already checked if it helps?

https://connect.microsoft.com/SQLServer/feedback/details/776248/could-not-load-file-or-assembly-microsoft-visualstudio-tools-applications-core

Mad_Don on Sun, 07 Sep 2014 23:07:47


Hi Ivan

Thank you so much for this.

It has helped me and it worked perfectly.

Thanks

Martin