.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Data Mining Project in BIDS: Why cant data source views be based on a query?

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
I've created an analysis services project in BIDS with the intention of creating a mining strucuture. I notice that you cannot create a data source view based on a query and that it must be based on linking actual tables (via the access looking GUI).  In my scenario I have a very long and complicated query which uses temp tables to retreive the data I want to use for mining.   Am I forced to insert this data into a table in order to create and use a mining structure?  Or are there other ways to do it?

View Complete Post

More Related Resource Links

SSRS 2008 R2 Data Source View Wizard does not recognize unique key constraints on views when using O

Hi, SSRS Data Source View Wizard does recongnize Primary/Foreign Key relationships from oracle datasouce tables, but does not recognize unique key constraints on views. How can I solve this problem. Thanks

Cant open dtsx project when the data source is Excel

hi All, i have problem opening my dtsx file. it returns error like: TITLE: SQL Server Import and Export Wizard ------------------------------ An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ------------------------------ ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.  ({004CD349-A469-43E7-AE5E-CDA5629AEBFB}) ------------------------------ The connection type "EXCEL" specified for connection manager "{AD831AF9-657F-4509-981E-EE593FDFA421}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.  ({004CD349-A469-43E7-AE5E-CDA5629AEBFB}) everything was working fine a week ago, when i try to open it again this mornging for modification, everything isnt good. any idea what should i do? thanks!!!AddinGanteng

Using CROSS APPLY in a data source query causes ARITHABORT error


I have an issue where the following query as an OLEDB data source throws the following error:

SELECT XmlNode.value('SomeValue[1]', 'varchar(10)') as SomeValue

FROM (SELECT CAST('<TestXML><SomeValue>123</SomeValue></TestXML>' AS XML

How To Map A GUID Variable And Use It In An OLE DB Source Data Flow Select Query


I have a simple SSIS package that does the following. 

On the control flow tab, there is an Execute SQL task that calls a stored procedure and returns a GUID. 

I have a package scoped variable that stores a UNIQUEIDENTIFIER output from the stored procedure. It appears that the package variable data type does not include a GUID data type so I tried to use string instead.

Next, the Execute SQL task is mapped to a data flow task. 
Within that data flow task I have an OLE DB Source which connects to a SQL Server Destination task.

On the OLE DB Source Editor screen I have a query that performs the following:

SELECT ID, SessionKey, ....
FROM dba_DroppedLoginsLog
WHERE SessionKey = ?

I have clicked on the parameters button to map the Parameter to my variable called User::SessionKey. This is the output variable from my Execute SQL Task component on the Control Flow tab. This value should be a GUID, but again, I don't see a data type for that.

When I execute the package it fails on the OLE DB Source with the following error:
[OLE DB Source [1908]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE D

Is there a way to query entity based on multiple filter criteria? WCF Data Services, Linq to Entiti


Instead of:

DW_CMSOPEN dwc = new DW_CMSOPEN(new Uri("http://acctdev02/WCFDataService/EmployeeService.svc"));

dwc.Credentials = System.Net.CredentialCache.DefaultCredentials;

var employees = from emp in dwc.Employees 
             where emp.DEPT == "123"
             select emp;

I'd like the linq query to resemble:

var employees = from emp in dwc.Employees
              where emp.DEPT // in {"123", "456", etc}
              select emp;

Is a Dynamic Config Possible for SSAS BIDS Projects? (Data Source / Connection, and Deployment Targe


How do we automate SSAS Project configs such that (a) RDBMS data source server (connection) and (b) SSAS deployment target server are dynamic? 

As it stands, just before I script the ASDB (for deployment/promotion from Dev to QA, or QA to Prod, for example), I use BIDS designer interfaces to change the source connection and deployment targets, then script the ASDB. 

Is there a more dyamic alternative?  Perhaps something analogous to SSIS package configurations?  I can't believe that everybody is doing this as manually as I've done.

error when testing query during configuring sql data source for gridview


I got the following error message:

There was an error executing the query. Please check the syntax of hte the command and if present, the types and values of the parameters and ensure they are correct.  Failed to enable constraints.  One or more rows contain values violating non-null, unique, or foreign-key constraints.

But when I run the query through Management Studio, I can get the result. 

There are no parameters for this query either. 

Can anybody give me a glue what to check?


use multiple data source views in one cube


Is it possible to use multiple data source views in one cube so I can organize each star with separate data source views?

This applies to SQL 2005 and SQL 2008 enterprise

Business Intelligence professional

Cannot refresh OLAP-based data in Excel Services workbook in browser (SP 2010 / Project Server 2010)



In SharePoint 2010, Project Server 2010, Business Intelligence Center, upon attempting to refresh OLAP data in an Excel chart in the browser, the following error appears:

An error occurred during an attempt to establish a connection to the external data source.  The following connections failed to refresh:

My ODC Connection Name

We have loaded and configured Project Server 2010 according to spec (http://technet.microsoft.com/en-us/library/ee662109.aspx).  Excel Services is configured according to spec (global settings, trusted file locations, trusted data providers and trusted data connection libraries).  The Secure Store Service is configured with the ProjectServerApplication target application. 

Non-OLAP data refreshes of spreadsheet data work fine in the browser.  OLAP data refreshes in the Excel client itself work fine.  Only the OLAP refreshes in the browser fail.  The problem occurs whether using a Microsoft ODC or one that we created (saved in a trusted location).

The ULS log has only one error, which is:

06/21/2010 13:47:17.86  w3wp.exe (0x1238)               &

Using Transact SQL Queries in Data Source Views


Afternoon all,

Can someone explain how I would use a view defined in SQL in my data source view creation and what the advantages of doing so would be. I've been assigned to a project where I need to build a DSV, but the database has a view that appears to create what I need too.

I've read in some MS literature that a view can be used in lieu of referencing the actual tables.

Can anyone explain how this would work?


DataReader Source Data Flow control not in the Toolbox of BIDS ???


I find this advice in the SSIS forum . . . but I can't find the DataReader Source in the Data Flow source items . . . nor do I seem to be able to 'Add Item' that time.

Advice appears to be I should use DataReader Source when pulling data from Oracle using ODBC e.g.:

"ODBC is supported in the data flow by the Data Reader source adapter. I think the original problem may have been that you were trying to use the Data Reader source with an ODBC connection manager.

To extract data from an ODBC source, try the following:

  • Add an ADO.Net Connection Manager.
  • Edit the Connection Manager editor and select the ODBC Data Provider
  • Configure the Connection Manager to use your DSN or connection string
  • Add a Data Flow Task to your package.
  • Add a Data Reader Source adapter to your data flow"

Any help getting the DataReader Source to appear in the BIDS toolbox appreciated.

Thank you and a Happy time with family tomorrow,



data mining project "harvest on how to depend other condition"


hi all,

I did a research about paddy cultivation in Sri Lanka using data mining technology. My goal was to find the association between cultivated area and harvest on how to depend other condition.please help me to continue  this . this is the link of the project details.



savi aluthgama



Passing report parameters to a query using a WCF data source


Hello everyone,


I am attempting to pass report parameters to my query. My report's data source is a WCF web service. I can run normal queries fine, but I have found that without the know-how to pass parameters to my query I am limited with my capabilities.

Assume a string parameter named "Name" with a specified default value of "Jmachol90", how would I pass that into the following query at the designated place:




          <Method Namespace="http://schemas.microsoft.com/sqlserver/masterdataservices/2009/09" Name="SecurityPrincipalsGetRequest">


          <Parameter Name="Criteria" Type="XML">









InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.


I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

Using a Query as a data source for a grid

Pardon the elementary nature of this question.  I have a SQL 2005 database with several queries.  I want to use the queries as data sources for grids in VS2008.  I connect the SQL database but cannot see the queries as a data source.  I have tried building the queries in code within VS but I still cannot use the query results as a grid data source.  Any Help would be greatly appreciated.

'Add project data source' database location?


Hey guys,

So I'm having trouble browsing for my databases in the Data Source Connection Wizard in Visual C#.

Just so you know where I'm at, here are the steps I've taken so far.

-> I click on my datagridview DataSource property and choose 'add project data source'.

-> 'Choose Data Source Type' -> database -> next

-> 'Choose Database Model' -> dataset -> next

-> 'Choose Your Data Connection' -> New Connection

Now I'm required to browse or type in my database string in the connection properties section and I don't know where my databases are stored.

Basically, what I'm trying to achieve is find the default location of where my sql server databases are stored on my hard drive so I can link them to my program.

Following my steps previously described I then press the 'browse' button and the FileDialog comes up directed at "C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples" which is where I find the northwind database.

I wish to locate a database I've created in sqlserver 2008, but cannot locate the database files anywhere on my hard drive.

I am able to achieve a connection through use of 'using System.Data.SQLClient' and creating a connection string, but would like to have to database as a datasource so I can work

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend