FIX: Error message when you try to add a configuration to a SQL Server 2005 Integration Services .dtsx package: "An error occurred while a new configuration was being added" (920298)


The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
Bug #: 408969 (SQLBUDT)

SYMPTOMS

When you try to add a configuration to a Microsoft SQL Server 2005 Integration Services .dtsx package, you receive the following error message:
An error occurred while a new configuration was being added.

Additional information
The path is not of a legal form. (mscorlib)

CAUSE

This problem occurs because the .dtsx package is not associated with a business intelligence solution.

RESOLUTION

Service pack information

To resolve this problem, obtain the latest service pack for SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

WORKAROUND

To work around this problem, associate the .dtsx package with a business intelligence solution. To do this, follow these steps:
  1. Start Business Intelligence Development Studio.
  2. Create a new Integration Services project.
  3. Add the .dtsx package to the Integration Services project. To do this, follow these steps:
    1. In Solution Explorer, right-click the SSIS Packages folder, and then click Add Existing Package.
    2. In the Add Copy of Existing Package dialog box, click File System in the Package location list.
    3. In the Package path box, type the location of the .dtsx package, and then click OK.
After you follow these steps, you can add a configuration to the .dtsx package without receiving the error message.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Service Pack 1.

MORE INFORMATION

Steps to reproduce the problem

  1. Put a .dtsx package in a folder so that the .dtsx package is not associated with a business intelligence solution.
  2. Right-click the .dtsx package, and then click Edit.

    The .dtsx package opens in Business Intelligence Development Studio.
  3. In Business Intelligence Development Studio, click Package Configurations on the SSIS menu.

    The Package Configurations Organizer dialog box opens.
  4. In the Package Configurations Organizer dialog box, click to select the Enable package configurations check box, and then click Add.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Modification Type:MajorLast Reviewed:6/29/2006
Keywords:kbsql2005sp1fix kbsql2005ssis kbExpertiseAdvanced KB920298 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.