Microsoft KB Archive/920298

= FIX: Error message when you try to add a configuration to a SQL Server 2005 Integration Services .dtsx package: &quot;An error occurred while a new configuration was being added&quot; =

Article ID: 920298

Article Last Modified on 6/29/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition
 * 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.



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:  Start Business Intelligence Development Studio. Create a new Integration Services project. Add the .dtsx package to the Integration Services project. To do this, follow these steps:  In Solution Explorer, right-click the SSIS Packages folder, and then click Add Existing Package. In the Add Copy of Existing Package dialog box, click File System in the Package location list. In the Package path box, type the location of the .dtsx package, and then click OK.</li></ol> </li></ol>

After you follow these steps, you can add a configuration to the .dtsx package without receiving the error message.

<div class="status_section">

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

<div class="moreinformation_section">

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.
 * 1) In Business Intelligence Development Studio, click Package Configurations on the SSIS menu.

The Package Configurations Organizer dialog box opens.
 * 1) 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

Keywords: kbexpertiseadvanced kbsql2005ssis kbsql2005sp1fix KB920298

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.