Issue time10:06:00 am, by Tom Green Email 2652 views
Categories: SSIS, Errors


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.  



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 »

Tags: .dtproj

Leave a comment
Issue time10:51:00 am, by Tom Green Email 2091 views
Categories: SSRS, Errors


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")




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 »

Leave a comment
Issue time08:56:00 am, by Tom Green Email 2862 views
Categories: SSIS, Errors


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 »

Leave a comment
Issue time12:34:00 pm, by Tom Green Email 4166 views
Categories: SSAS, Errors


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.



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


Full story »

Leave a comment
Issue time07:01:00 am, by Tom Green Email 2214 views
Categories: SQL Server, Errors


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


   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



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


Full story »

Leave a comment
July 2024
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
  1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31      


Email Subscription

Enter your email address:

Delivered by FeedBurner



XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...


Which database platform do you use?

View Results

Powered by b2evolution