.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

The PerformUpgrade method failed opening SS2008R2 package on SS2008SP1

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
 
A colleague of mine developed a package with Visual Studio 2008 SP1 and SQL Server 2008 R2. When he handled the package to another colleague that had Visual Studio 2008 SP1 and SQL Server 2008 SP1 installed, the following error occurred for every ADO.NET Destination: Error 1 Validation error. Process File Detail: Process File Detail: The component metadata for "component "<component name>" (2135)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. <package name>.dtsx 0 0 Since I also have SQL Server 2008 R2 installed on my machine and the target environment is SQL Server 2008 SP1, do I need to downgrade my SQL Server installation, or is there a way for a developer with SQL Server 2008 SP1 to open and compile the packages?Paulo Morgado


View Complete Post


More Related Resource Links

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:

  

 Hello...

Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

[WebMethod]
        public static string aaa(int i)
        {
            Thread.Sleep(1000);
            return i.ToString();
        }

        [WebMethod]
        public static string aaa1(int i)
        {
            Thread.Sleep(1000);
            return i.ToString();
        }

 

 

<div>
        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        </asp:ScriptManager>
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

Package 'DataWarehouse VSIntegration layer' has failed to load properly

  
Hi, In my VSTS, I am not able to create a new SSIS project. When VSTS Opens It gives me following error: --------------------------- Microsoft Visual Studio --------------------------- Package Load Failure Package 'DataWarehouse VSIntegration layer' has failed to load properly ( GUID = {4A0C6509-BF90-43DA-ABEE-0ABA3A8527F1} ). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading. --------------------------- Yes   No   ---------------------------   Also, in Tools the options for Business Intelligence designer is missing.   Please help me!!Sonia Mawandia http://sqldeveloper-sonia.blogspot.com/

Package 'Microsoft.VisualStudio.Xaml' has failed to load properly

  
I can't use WPF designer.I tried some commands to fix it ('devenv /resetskippkgs' & 'devenv /resetsettings') but nothing change.This is the complete error message---------------------------Microsoft Visual Studio---------------------------Package Load FailurePackage 'Microsoft.VisualStudio.Xaml' has failed to load properly ( GUID = {E58C2A8B-BCC4-4559-AD59-D62EB6D58A22} ). Please contact package vendor for assistance. Application restart is recommended, due to possible environment corruption. Would you like to disable loading this package in the future? You may use 'devenv /resetskippkgs' to re-enable package loading.---------------------------Yes   No   ---------------------------Some days ago WPF Designer worked correctly and I didn't install anything new on my pc.Can someone help me ?Many thanks claudio

Sharepoint SDK Installation - "The installation of this package failed"

  
I'm attempting to set up a Sharepoint development environment in a local VM. Currently I have installed: Windows Server 2008 R2 Standard x64 Sharepoint Server 2010 (single server standalone) Visual Studio Professional 2010 When I try and install the SDK I get the dreaded "The installation of this package failed". I have plenty of space on the system volume. Extract from the log: OPatchInstall: Getting the data from the file 'C:\Users\sam.ritchie\Desktop\SharePointPlatformSDK.exe' OPatchInstall: Thrown CDetectionExceptionWin32(0) OPatchInstall: Setting system property 'SYS.ERROR.INERROR' with value '1' OPatchInstall: Setting system property 'SYS.ERROR.CODE' with value '0x0' OPatchInstall: Setting system property 'SYS.ERROR.TYPE' with value 'WIN32' OPatchInstall: Setting system property 'SYS.ERROR.ARG1' with value 'NONE' OPatchInstall: Setting system property 'SYS.ERROR.ARG2' with value 'NONE' OPatchInstall: Setting system property 'SYS.ERROR.ARG3' with value 'NONE' OPatchInstall: Setting system property 'SYS.ERROR.ARG4' with value 'NONE' OPatchInstall: Setting system property 'SYS.ERROR.ARG5' with value 'NONE' OPatchInstall: Done executing action I'm not sure what I'm missing here?

package 'Visual Web Developer HTML Source Editor Package' has failed to load

  
Hi All  I am using VS 2008 Team Edition with SP1 installed. All was fine till yesterday when i started receiving the error 'package 'Visual Web Developer HTML SourceEditor Package' has failed to load properly (GUID={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}}' . I am able to build the project and can do work in cs files but no support for the design view. Reinstall is not fixing this, Please HELP

Warning Message while i'm opening SSIS package

  
Hi, I'm getting below mentioned Error message whenever i'm opening the package. anybody came across same problem kindle help me to resolve the issues. "Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file?"   Regards, Sabarinathan

.NET Framework 4.0 Full package installation failed with error code: (0x80070643)

  
I am getting an error when installing .net framework 4.0. I am using the full package installer. OS: windows XP Service Pack 3 Windows Update: Current with all security updates. Error: [7/12/2010, 10:50:49]MSI (C:\eb1ddbb12a129b2fddde4054\netfx_Core_x86.msi) Installation failed. Msi Log: Microsoft .NET Framework 4 Setup_20100712_105014316-MSI_netfx_Core_x86.msi.txt [7/12/2010, 10:50:49]PerformOperation returned 1603 (translates to HRESULT = 0x80070643) [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:49]OnFailureBehavior for this item is to Rollback. [7/12/2010, 10:50:49] Action: Performing actions on all Items... [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:49] Action complete [7/12/2010, 10:50:57]C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz - Signature verified successfully for netfx_Extended.mzz [7/12/2010, 10:50:57] C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz Signature verified successfully for netfx_Extended.mzz [7/12/2010, 10:50:57]Signature verification succeeded for netfx_Extended.mzz [7/12/2010, 10:50:57]File C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz, locked for install. [7/12/2010, 10:50:57]Verifying Digital Signatures: C:\eb1ddbb12a129b2fddde4054\netfx_Extended.mzz Success [7/12/2010, 10:50:57]Final Result: Installation failed with error code: (0x80070643), "Fatal error during installation. " (Elapsed time: 0 00:00

Implementing Transaction in SSIS Package - [Execute SQL Task] Error: Failed to acquire connection "<

  
I have a simple SSIS package with three "Execute SQL Tasks". I am using ADO.Net Connection to execute SPs on a DB server. When I execute this package It works fine. So far so good. Now, I need to implement transation on this package. And problem starts now onwards. When I try to execute package after setting TransationOption = Required for the Sequence container which contains all the tasks, I get following error. [Execute SQL Task] Error: Failed to acquire connection "NYCDB0008.Export". Connection may not be configured correctly or you may not have the right permissions on this connection. "NYCDB0008.Export" is the name of the ADO.Net connection. I have been hunting for any solution but all in vain. I have tried changing all DTC settings on the dev as well as Database server. Please respond if anyone has any solution. Thanks! Anand

"Failed to save package file" error

  

I receive the following error while trying to create a new project in BIDS:

"Failed to save package file "C:\Users\<username>\Local Settings\Temp\2\tmpCAD.tmp" with error 0xC020207E "The file name is not valid.  The file name is a device or contains invalid characters"

Environment is:

Windows 2008 Server SP1 (64 bit)

Visual Studio Team System 2008

Any ideas?


Server method failed

  

Hi,
Iam getting server method failed when calling a page method using js.
My page method retrieve more than 6500 data rows from Db. these rows are concatenated to a string and returned. When the number of is rows less than, means below 2500 it working fine. But if goes more it says server method failed .
each rows contain a string of length more than 30.

What i have to do in this case?


SSIS package failed for huge data

  

Hi ALL,

I have created one package to archive database. The target database is around 400 GB data and source db is around 300 GB. I have the Lookup control to check the duplicates in the data. The package is working fine with small amount of data. but it is giving the errors when I am trying to archive some 400 GB of data. Getting the below errors while running the package

1)Communication link failure
2)TCP Provider: An existing connection was forcibly closed by the remote host
3)OLE DB error occurred while populating internal cache. Check SQLCommand and SqlCommandParam properties
4)failed the pre-execute phase and returned error code 0xC020824E.

Appreciating your help in advance


Thanks,
Loknath


Method 'Post' of object 'IOWSPostData' failed

  
Hi!

I have Microsoft Office 2003 and Microsoft Sharepoint Designer 2007 on the
same machine. I have a problem uploading an excel spreadsheet into WSS 3.0.
I get Method 'Post' of object 'IOWSPostData' failed error. I have followed
this article (http://mindsharpblogs.com/Kathy/archive/2008/03/16/4450.aspx)
but it doesn't resolve the issue.
Pls, advise how can I resolve this.

Thank you in advance!

Zaur


MsiGetProductInfo failed to retrieve ProductVersion for package during install

  
I keep getting this when trying to install SQL Server 2008 Workstation Components on a Vista Premium PC that has SQL Server 2005 tools on it.

MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.

I have tried all kinds of cleanup of the 2005 version to no avail (Uninstall, MS Install Cleanup Utility, Registry cleanup, Old SQL Server directory deletes, etc... ).

Wipe PC and start over is not an option.

Any suggestions?  What the heck is it looking for? 

I have reinstalled my SQL Server 2005 tools and have no mention of '
2243F21A-E132-44F7-BA13-024D0845C815' in my registry, but 2008 tools still do not want to install.



Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -289740454
  Exit facility code:            1722
  Exit error code:               59738
  Exit message:                  MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code = '{2243F21A-E132-44F7-BA13-024D0845C815}'. Error code: 1605.
  Start time:                    2008-09-04 14:33:37
  End time:       

Setup failed - no package

  

I tried to install a sql 2005 desktop engine. This fails with the error:Tongue Tied

An installaton package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'

 

I used a fresh, new download SQLEXPR.EXE.

What shall I do?

 


Error, to access method failed

  

Salam To all,

please find my scenario,

i have two Class projects A,B and i have Webapplication project,

the web application call Class A,

the class A make some internal operation with class B.

when a function in a class A attempts to call Entities in Class B, i have the following Error:


Attempt by method 'Txns_Model.Txns_Configuration..ctor()' to access method 'System.Linq.Expressions.Expression.Lambda<System.Func`2<Txns_Model.Txns_Entity,Users_Model.Users_Entity>>(System.Linq.Expressions.Expression, System.Linq.Expressions.ParameterExpression[])' failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.MethodAccessException: Attempt by method 'Txns_Model.Txns_Configuration..ctor()' to access method 'System.Linq.Expressions.Expression.Lambda<System.Func`2<Txns_Model.Txns_Entity,Users_Model.Users_Entity>>(System.Linq.Expressions.Expression, System.Linq.Expressions.ParameterExpression[])' failed.

Source Error:

Failed to load at least one of the configuration entries for the package

  

When i run my SSIS package through sql server agent, i got the error below.

Please any one tell me abt the reason of this error

(1) I have credential created which used AD directory service account with userid   and password:  Userid=DONTCALL_AppPool

(2) Created a proxy which use the creddential above

(3) I used Environment variable configuration and sql server configuraion

1984-2005. All rights reserved.    Started:  1:44:41 PM  Error: 2010-10-01 13:44:42.16     Code: 0xC0202009     Source: DontCall Connection manager "CRBSSISConfig"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'CBCINTERNAL\DONTCALL_AppPool'.".  End Error  Warning: 2010-10-01 13:44:42.16     Code: 0x80012059     Source: DontCall      Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.  End Warning  Error: 2

SSAS failed in SSIS package

  

Hi,

 Master Package containing
    a) A sequence of SSIS packages
    c) Precedence constraint to
    b) Analysis Services Processing Task to process our cubes
2. SQL Agent Job which runs the Master Package

Taking the cube processing in SSIS package and putting SSAS commands into the job
This seems to work, but we don't know why it is not working.

Im using

Native OLE DB\Microsoft OLE DB Provider for Analysis Services 10.0
as OLE DB provider, as  connection information

In BI SSAS cubes are working fine.

But SSAS cubes in SSIS package showing the following error


"Internal error: The operation terminated unsuccessfully. "

Pls help me to solve

Thanks


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend