FIX: You may receive an error message when you try to run an SSIS package in SQL Server 2005 (918091)


The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Developer Edition
Bug #: 50000154 (SQL Hotfix)
Bug #: 432176 (SQLBUDT)


Microsoft distributes Microsoft SQL Server 2005 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2005 fix release.
This article describes the following about this hotfix release:
  • The issues that are fixed by this hotfix package
  • The prerequisites for installing the hotfix package
  • Whether you must restart the computer after you install the hotfix package
  • Whether the hotfix package is replaced by any other hotfix package
  • Whether you must make any registry changes
  • The files that are contained in the hotfix package

SYMPTOMS

If you try to run a Microsoft SQL Server 2005 Integration Services (SSIS) package, you may receive an error message that resembles one of the following error messages:

Error message 1

The variable "User::MyVariable" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Error message 2

Reading the variable "User::MyVariable" failed with error code 0xC0010009. The expression "@[User::MyVariable]+"\\"+ @[User::MyType]" on property "ServerName" cannot be evaluated. Modify the expression to be valid.
The error messages may be reported in several locations:
  • When you try to run an SSIS package by using the dtexec command-prompt utility, the error message may be reported in the console window of the command line.
  • When you try to run an SSIS package by using SQL Server Business Intelligence Development Studio, the error message may be reported in the Business Intelligence Development Studio output window.
  • When you try to run an SSIS package and you use a log provider to redirect the execution output, the error message is reported in the redirected output.

CAUSE

This problem occurs when the following conditions are true:
  • Several tasks in an SSIS package are run in parallel.
  • The SSIS package uses property expressions that contain variables.
When several property expressions use the same variable and the property expressions are evaluated in parallel, more than one property expression may access a single variable at the same time. When more than one property expression accesses a single variable at the same time, this problem occurs.

RESOLUTION

To resolve this problem, install the cumulative hotfix package (build 2153) for SQL Server 2005 that is discussed in Microsoft Knowledge Base article 918222. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is available

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

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

For more information about how to use property expressions in packages, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms141214.aspx

Modification Type:MinorLast Reviewed:7/26/2006
Keywords:kbsql2005sp1fix kbBug kbfix kbtshoot kbQFE kbhotfixserver kbpubtypekc KB918091 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.