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?
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