Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 824
  • Last Modified:

Error 1 RelationalDataSource [IFS] : A target data source is not SQL Server

I am having an issue with this error when I buld, I am not sure how to get past the problem

Error      1      RelationalDataSource [IFS] : A target data source is not SQL Server.            0      0      


can someone please help
0
Jayesh Acharya
Asked:
Jayesh Acharya
  • 12
  • 4
1 Solution
 
Bob LearnedCommented:
Things I know:

1) SQL Server 2008

2) Data mining

3) Analysis Services

4) RelationalDataSource

http://msdn.microsoft.com/en-us/library/microsoft.analysisservices.relationaldatasource.aspx

Things I don't know:

1) SQL Server 2008 R2?

2) Are you working with any other databases, or just SQL Server?

3) What does the connection string look like for the RelationalDataSource (without sensitive information)?

4) What is the RelationalDataSource.ParentServer property set to?
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
This is only a sql server 2008 but you might know some parts.

I am connecting to oracle 10g as thats where I have build the fact / dimension tables and using microsft for the analsys services

the oracle connection is using

.Net Providers\OracleClient Data Provider
         OracleClient Data Provider

--Server name

User name
Password

I check the Save my password

I test the connection and it works fine

Oracle 10 g is 64 bit sitting on a Windows Platform

The SQL Server is 32 bit on a Virtual Machine

Now I have built one cube and it works fine, with my second cube I get the errors listed. The only difference between the two has been the actual Facts and Dimensions that I build on the Oracle database.

Now I am using Visual Studio 2008 to build / deploy the cube. but i get the error listed. Also when I try to process I get duplicate data errors which when i check the data are not duplicate. But to get past the processesing I process the data on the Sql Server which seems to work. But I am still left with the IFS error.

Not sure even where to look to try to solve the issue
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
The Deployment properties:

Options:
    Processing Option                 Do Not Process
    Transactional Deployment     False
    Deployment Mode                  Deployment Changes Only

Target
   Server                                    XXXX-SQLTEST\MSSQLSERVERXXTEST
   Database                               Sales Ana;ysis
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Bob LearnedCommented:
Hmmm...here I thought that SSAS didn't work with Oracle...you say that you have one cube working with Oracle, and one that isn't?
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
where do i find RelationalDataSource.ParentServer in Visual Studio?
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
yep  both cubes are in SQL Server

What we do is build the Facts, dimensions in oracle, then use Visual Studio to do a build and deploy to the SQLServer, which looks like it pulls the data from Oracle and places it into the SQL Server

Next we then process the data, which we can do directly from the SQL Server

0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
we use a connector provided by Microst to pull in the data
0
 
Bob LearnedCommented:
1) The fact that I am attempting to answer this question means that it fell through the cracks.

2) I am not the foremost expert on SSAS, so I need to think about stuff more than others.

3) If you look at the RelationalDataSource object, you can see that is has the ParentServer property, but it doesn't suggest how to check that property.

4) Can you attach a .png screen shot of what you are working with, so that I can get a context for my research.
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
I have added 4 pics, the first one shows the error, and the other three are the connections to the two databases, Oracle to pull the data and SQL server to push this data to the analysis services.

0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
ok In the end I closed everything out, copied the project to a different location and reopend it and then rebuilt and re-deployed and the error went away ..

I dont know why or how to explain why it went away, but some how I just think its a bug within Microsoft ...

Thanks for all the help
0
 
Jayesh AcharyaTechnichal ConsultantAuthor Commented:
while the person did not actually resolve the issue, it did help me to re think through the issue and go step by step and look at all pieces.

It was very helpfull for me as I am a newbe with this tool
0
 
Bob LearnedCommented:
Thanks for the information!!  It was going to take me a while to get to a place where I could either duplicate the error, or find a reference article that explained the problem.  I would still be looking...
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 12
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now