Cumulative update package 3 for SQL Server 2008 SP 1

08/08/2009

תגיות: , , ,
תגובה אחת

Hi all,

CU 3 for SQL 2008 SP 1 has released and can be download here.

The file version is 2007.100.2723.0.

It has resolved 2 problems I have encountered with:

1. Problem: In Microsoft SQL Server 2008, you create a SQL Server Integration Services (SSIS) package. This SSIS package contains an Execute SQL Task that uses an OLE DB connection. The Execute SQL Task runs a stored procedure that has an output parameter of the DateTime data type. In the SSIS package, you create a package variable of the DateTime data type. You map the output parameter of the stored procedure to the package variable. In this scenario, when you run the SSIS package, you receive the following error message:

[Execute SQL Task] Error: Executing the query "Query" failed with the following error: "The type of the value being assigned to variable "Variable" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. ".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

2. Problem: In Microsoft SQL Server 2008 Analysis Services, you design an Analysis Service project in Business Intelligence Development Studio (BIDS).

  • You define a referenced dimension relationship for a measure group in a cube. You click to select the Materialize check box when you define the referenced dimension relationship.
  • You make a change to a calculation script command, and then you save the change. For example, you add a space to the calculation script command, and then you save the change.

In this scenario, when you process a partition in the measure group, you receive the following error message:

Errors in the high-level relational engine. The binding for the 'ColumnName' column is not a ColumnBinding type.

I strongly recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release.

Be cautious,

Ronen

הוסף תגובה
facebook linkedin twitter email

כתיבת תגובה

האימייל לא יוצג באתר. שדות החובה מסומנים *

תגובה אחת

  1. romantika29/04/2011 ב 18:21

    It's straight to the point! In other words, and do not say! 🙂

    הגב