Problem

When trying to open a BI project, the following error appears.

'\PATH_TO_PROJECT\PROJECT_NAME.dwproj' cannot be opened because its project type (.dwproj) is not supported by this version of the application. 
To open it, please use a version that supports this type of project.  

Solution

First, make sure that you have BIDS (SQL Server Business Intelligence Development Studio and Integration Services installed.

If you have them already installed and still get the error, it is possible that you try to open in SQL Server 2005 BIDS (for example) a project created (upgraded) in Microsoft SQL Server 2008, 2008 R2, 2012.

Full story »

Problem

When executing an SSRS report the following error appears:

An error has occurred during report processing. (rsProcessingAborted)

Cannot set the command text for dataset 'DATASET_NAME'. (rsErrorSettingCommandText)

Error during processing of the CommandText expression of dataset ?DATASET_NAME?. (rsQueryCommandTextProcessingError)

The report is using two parameters based on two different datasets.

The dataset of Parameter_1 is defined by the following query (this is just a simple example for better understanding):

=IIf(Parameters! Parameter_2.Value Is Nothing,"select 1","select 2")

Solution

Check if the query is not missing any quotes. If this doesn?t solve the problem take a look at the parameters order.

Full story »

Problem

When executing an SSIS package the following error appears:

A rowset based on the SQL command was not returned by the OLE DB provider.

Component "COMPONENT_NAME" failed the pre-execute phase and returned error code 0xC02092B4.

In my case, I received the error when running a SQL job that brings some data from several servers to another one during the night. The job executes a SSIS package that uses a data flow task.

In the data flow task, a stored procedure is executed and the results generated from the source servers are inserted into a table on the destination server.

Full story »

Problem

When trying to call DiscoverSessions function from the ASSP procedure the following error can appear.

CALL ASSP.DiscoverSessions()

Execution of the managed stored procedure DiscoverSessions failed with the following error: Exception has been thrown by the target of an invocation.The type initializer for 'Microsoft.AnalysisServices.Xmla.NamespacesMgr' threw an exception..

The error is received out of the blue, after many successful executions during several months.

Solution:

Delete the existing assembly and register the DLL again from Management Studio.

Full story »

Problem

The following error appears when trying export data from SQL Server to a network share with BCP utility:

xp_cmdshell 'BCP "SELECT COLUMN_1, COLUMN_2, .. COLUMN_N FROM TABLE_NAME"
   QueryOut \\SERVER_NAME\SHARED_FOLDER\FILE_NAME.TXT -c /t \t /r \n /S SERVER_NAME /U user_name /P user_password'

SQLState = S1000, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

Solution

Grand the user that writes to the network share the necessary rights. 

Full story »