Hello Everybody, I am using SAS Olap cubes, i would like to connect those OLAP Cubes using SSIS and need to perform some ETL process, could you guys please let me know the solution,thank you.
View Complete Post
I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.
but now it do not work more with the error:
Error at create server:
Error Source Description HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure Clase no registrada NULL 0
(1 row(s) affected)
I found this article:
It means that I can not process the cube using the same method any more ?
We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second
attempt to connect will get the message :
Connection to <filename> server, <dbname> database, <cubename> cube failed. OLAP Server error: The following system error occurred: The process cannot access the file because it is being used by another process. ., File system
error: An error occurred while opening the '<filename>' local cube file.
This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.
Is there any way to solve this without users taking copies onto their workstations?
I have a cube that I am accessing through excel 2007 pivot tables. I have a field that shows values with reverse signs. The negatives show as positive and the positive show as negative. Is there a way in Pivot table to reverse the sign? I can create a formula
to do this, but I want this calculated column to appear in the middle of pivot table columns as the client would like a certain order of columns. Any ideas?
Thanks in advance!
I used to connect my OLAP database with this connection strings :
"Data Source=http://<target IP>/olap/msmdpump.dll;Catalog=<cube name>;Impersonation Level=Anonymous;"
but somehow, it managed to be disconnected for some other reason...
then, i try to not using HTTP connection...
""Data Source=<target IP>;Catalog=<cube name>;Impersonation Level=Anonymous;"
the result is, I cannot connect to my OLAP..
Any suggestion? I want to connect my OLAP without using HTTP connection...
Best Regards and Thanks,
I'm using SSIS SQL 2008 connect to MS-Access MDB via OLE DB Jet 4. I used to work but now I couldn't connect any more. I got "connection failed because of an error in initializing provider. unspecified error." I still can connect the via SSIS SQL 2005.
Really need help..
the connection failed because of an error in initiallinzing provider. ora-01017: invalid username/password; logon denied.
but can connect from SQL PLUS.
My local pc does not connect to SSIS. Is there something I need to do set up the connection?
Hi, I have an issue where I am trying to reduce the time it takes to load SSAS cube data to SQL table using SSIS.
Within a Data flow task I have an OEDB source where in I select "command from variable" where the variable holds the dynamic MDX. I then have a data conv, lookup, derived transform and OLEDB destination respectively.
However the load takes some 2.5 hours for inserting 1 million rows. Any pointers as to how I may reduce it?
I have around 110 columns returned from the source MDX and it has 1 million rows as I said.
the lookup is to get a key not present in cube. since the lookup table is huge, i am using partial cache and the derived column transform just adds a string (hard coded) value of "ETL" and a time using getdate(). Data conversion is for the obvious conv for
ntext data (returned from MDX to corresponding datatypes in SQL table...I have the fast load option in the OLEDB destination.
I can't use openquery though. Let me know what may I do to reduce the load time.
In datasource designer for adding a new data source, I am attempting to connect to an oracle server. I then enter credentials and click 'test connection', and get this error.
Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect indentifier specified.
I am using Oracle 11g as my framework.
The strange thing is if i use enterprise manager using 10.2.1 oracle framework, I cannot see any tables. The only way I can see tables if I go and click on "other users" and then click on the specific user previous employees have used as their login credentials to generate an SSIS package.
I have already set up the access using enterprise manager, but ssis does not follow? Or something?
Thank you in advance.
I have an SSIS package that has 10 data flow tasks that was created in Visual Studio 2005.
Each one has a different OLE DB Source but the same OLE DB Destination table.
I am moving from one 2005 server (A) DB to 2008 server (B) DB. The DB has the same name. The 3 connections used for the 10 different OLE DB Source will be on server (B). The 1 connection used for the 10 different OLE DB Destination will be on server
(B). The same OLE DB Destination table is also on server(B).
When I convert this package to Visual Studio 2008, I lose my connections and have to change each one to the connections on server (B).
Is there a way to change the OLE DB Connection manager 1 time, without having to change it 10 times for the OLE DB Source?
Is there a way to change the OLE DB Connection manager for the OLE DB Destination 1 time, without having to change it 10 times for the OLE DB Destination table.
Thanks for your help.
Here is a very simple scenario:
a asp.net application retrieves data from remote SSAS 2008R2 CUBE.
string conString = "Data Source=10.1.1.5;Catalog=Adventure Works DW 2008;";
AdomdConnection con = new AdomdConnection(conString);
AdomdCommand command = new AdomdCommand("select from [Adventure Works_1]");
AdomdDataAdapter da = new AdomdDataAdapter("select from [Adventure Works_1]",con );
DataTable dt = new DataTable();
I already set:
1. localservice, anonymous, network service accounts in both SSAS Instance Security and SSAS DB roles.
2. RequireClientAuthentication = false.
unfortunately, I always got the following message:
"An existing connection was forcibly closed by the remote host"
Should I set up HTTP access for SSAS? and why?
Thank you very much for your kind help!!!