Is there any way that cubes built on Analysis Server 2005 can be migrate or copy to Analysis Server 2000. I have built cubes on 2005 and i want the cubes to be also on another server whicih is unfortunately running Analysis Serviuces 2000. Is it poosible ?
thanks for tht time
Süleyman writes "I want to transfer databases with cubes and virtual cubes from SQL 2000 Analysis Server to SQL 2005 SQL Express.
1.how i can transfer the cubes?
2.how i can transfer the virtual cubes?
3.Why i see the tables(saw)and the cubes in SQL Managment only under Tables together and nothing under cubes?
Please help me
many thanks
Süleyman from Germany/Frankfurt am Main"
Hi there
I have two machines one 64bit machine with SQl 2005 on it and another 32 bit machine which I use as my web server both running win2003. I have followed the knowledgebase article from Microsoft (http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx) and also researched postings on this site but can't seem to access the cubes remotely. I have changed to msmdpump.ini file to have the <ServerName>mycomputername</ServerName> which points to the SQL box.
I can connect to the cubes from the 32 bit machine using somethign like crystal reports and connecting directly to the server name but can't connect to https://localhost/olap/msmdpump.dll I get an error about could not connect to the computer name or the computer is not runing analysis services.
Any ideas?
Cheers,
Derek
Hi,
I'm am writing a report in SSRS 2005 on a local PC that uses cubes in AS 2000 on another server as a datasource. I am using the Microsoft SQL Server Analysis Services Extension (OLAP9) to connect to the cubes using windows authentication. I can save and preview the report in visual studio and publish the reports on IIS on my local PC with no problems but when I go to view the report in IE, I get the following error:
An error has occurred during report processing.
Query execution failed for data set 'dataset'.
Unable to recognize the requested property ID 'ReturnCellProperties'.
Have read various articles on the net with no conclusive explanation.
I have seen another post on this forum that suggests using OLEDB for Analysis Services instead but if I do this it doesn't allow me to use the MDX visual query designer. Creating the report using OLAP9 then changing to OLEDB and pasting in the query code doesn't work so well either.
I went and read http://technet.microsoft.com/en-us/library/ms159219.aspx about data sources supported by SSRS 2005 and it should be ok.
I am using sql server 2005 with the latest service pack 2.
Any ideas?
Hi,
Can anybody tell me How to access Analysis Service 2005 cubes through normal Stored Procedure.
Basically can write a stored procedure that we normally write in database service and use it access the Analysis Service 2005 cubes.
Is it possible
Regards,
gokul
Hi All,
I am looking for a way to export a sql server 2005 table to xml using VB or C#. This is done easliy with MS Access but I am having trouble finding any information for SQL SERVER 2005.
Thanks for the help,
Bones
I can not find "import/export" in SQL Server 2005 "microsoft SQL Server Management Studio Express" How do I move a database from SQL Server 2000 to SQL server 2005?
View 5 Replies View RelatedI have a good size database (113 tables & views, each with an average of ~15 columns). I'd like to use SQL Server 2005 to create a basic table-layout diagram with fields for the DB, and then move that diagram to Visio or similar (even a bitmap) for additional annotations and updates. What I've seen so far with the tool that comes with SQL Server is that it's about good enough to do the initial generation and save me the work of having to type out the ~1600+ fields plus the relationships, but would be clumsy to use after that.
Unfortunately, so far I haven't seen a way to do any kind of export. It doesn't even want to let me print it (though it will, oddly, layout page-breaks for me). I'm currently using SSMS Standard edition (not express, but not pro either), so if that's the problem we do have a pro liscense for only one of the users here- I might be able to get him to do the export for me.
Hi,
do someone know how can I schedule an "export data" job?
I have to write a script?
I appreciate your help. Thanks
Regards,
Tom
I'm new in SQL. I must write query that finds a specific data.
you have two tables one is the user table the other is the role table.
In the user table, there is someone who called "Alfred" and his role is saved in the role_name field in role table. Ultimately, I must find "Alfred's role". I will thank to anyone who gives me a hand.
Hi whoever can help,
I have created a web site using VWD platform.
DB tables have been created with the build in facility within Visual Web Developer tool.
Now that I have hosted my site (towardes production) I do need to pupulate/create all the tables on the hosting server (that includes ASPNETDB tables).
I guess some export tool can help (have tried with SQL Server Management Studio Express but I can not figure out how to perform the task.
Can you please help on that.
Thanks & Best Regards
Hi!
I just used the SSIS Import and Export Wizard to copy 50+ tables from SS05 to SS2K.
I found that the wizard created a package that I could not figure out how to edit, e.g., to change whether or not it had to CREATE a table, or just use an existing one. (I created some problems by manually editing the receiving table names to be ones that already existed -- but the original names it had did not exist, so it knew it had to create them. What I should have done, and eventually ended up doing, was scroll through my list of tables in the "receiving" box; I just figured editing the name would be faster, not realizing what problems I would create for myself.)
Anyhow, now that I see the complex package that the wizard creates, with a LOOP over the 50+ tables, I would like to know how/where in the package it is storing the information about the tables to copy.
Basically the wizard creates the following Control Flow tab entries (in processing sequence order):
an Execute SQL Task: NonTransactableSql
an Execute SQL Task: START TRANSACTION
a Sequence Container: Transaction Scoping Sequence, which contains
an Execute SQL Task: AllowedToFailPrologueSql
an Execute SQL Task: PrologueSql
a Foreach Loop Container, which contains
a Transfer Task with an icon I did not notice in the Toolbox
an Execute Package Task: Execute Inner Package
an Execute SQL Task: EpilogueSql
an "on success" arrow to
an Execute SQL Task: COMMIT TRANSACTION
an Execute SQL Task: PostTransaction Sql
an "on failure" arrow to
an Execute SQL Task: ROLLBACK TRANSACTION
an Execute SQL Task: CompensatingSql
Where, and how, can I look within this package to see the details about the tables I am transferring? I see that one of the Connection Managers is "TableSchema.XML" -- but it points to a temporary file on my hard drive, that I presume is populated by the package. Where does it get its information?
This is certainly much more complex than the package I would have written, based on my limited knowledge of SSIS. I would have been inclined to create 50+ Data Flow tasks, one for each table.
So now I'm trying to understand why the Wizard created this more-complex package.
Any help will be appreciated, including references to non-Microsoft books/websites/etc.
Thanks in advance.
Dan
Where is that neat little "Import/Export" DTS Wizard like I had in SQL Server 200 Developer?Or am I going to have to mess with the script generation features?
View 2 Replies View RelatedHi, I"m trying to export a databse from my express 2005 to 2000 and I tried using managment studio and doesn't seem to work. Can anybody give me some tips or links that teach me how to do that? I googled around , so far, havne't found a good solution yet. Thanks
View 1 Replies View RelatedI want to export Excell 2003 to Sql Server 2005. I am having the following error while execute the query.
declare @SQL varchar(8000)
create table #temp(i int identity(1,1),SiteName varchar(100),SiteDescription varchar(5000),SiteURL varchar(500),CategoryName varchar(200))
set @SQL='Insert into #temp Select * From OPENROWSET (''Microsoft.Jet.OLEDB.4.0'',''Excel 8.0;Database=' +
'a.xls' +';HDR = YES;IMEX=0'',''SELECT * FROM [Sheet1$]'')'
exec (@SQL)
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
I need a solution urgently. help Pls
I had a report that exported to PDF just fine before installing SP2 and now it is completely messed up. The report consists of a table that has two header rows (the report is basically a calendar). First Header Row is Month - merged across all 7 columns, Second header row is day of week. The next row is a row containing the date and finally the last row contains the actual data that is populated into each day. It is a sub-report in each cell of the row. It used to export fine but after applying SP2 it exports to pdf like this:
1st page is the first header row (Month) - Nothing else on the page
2nd page is the 2nd header row (Day of Week) - Nothing else on this page.
3rd page is the 1st row of actual dates - Nothing else on the page.
4th page is the data that goes to that 1st row of dates on the 3rd page, this page all all following pages are fine and show the row with the date directly above the data row with no page breaks in-between.
There is nothing in any of the controls forcing a page break (remember, it worked fine up until SP2 was applied).
What did the SP break? I am unable to modify my report now so that it exports to PDF correctly. What the heck???
Hi! I have XP sp2, with SQL server 2005 Developer Edition 9.00.3054.00 and also have Microsoft SQL Server Express Edition 9.00.3042.00, well my problem alway I want import data into any server from any data source I recive this message:
TITLE: SQL Server Import and Export Wizard
------------------------------
The operation could not be completed.
------------------------------
ADDITIONAL INFORMATION:
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified. (System.EnterpriseServices)
------------------------------
Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified.
------------------------------
The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
------------------------------
BUTTONS:
OK
------------------------------
I have this name space but, I try for many ways and I can't import data in my server, What can I do???
Thanks a lot.
Hello there,
Do any of you know about SQL 2005 Export problems?
We used to be able to use the Wizard to export a database to an excel file with SQL 2000, now SQL 2005, gives us an error. Here are the settings:
Data Source: SQL Native Client
Use SQL Server Authentication
Destination: Microsoft Excel. Excel version 97-2005 (check first row has column names) on local host
Copy data from one or more tables/views
Select all tables (72)
Execute Package immediately
This is the report:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Prepare for Execute (Error)
Messages
Error 0xc0202009: {7C16471E-54A0-4A65-97AD-EFAA33B909F2}: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".
(SQL Server Import and Export Wizard)
Error 0xc020801c: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task: component "Destination 64 - USERS" (5871) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [TABLES] (Stopped) ......
- Post-execute (Stopped)
- Cleanup (Success)
MessagesInformation 0x4004300b: Data Flow Task: "component "Destination - [TABLES]" wrote 0 rows.
(SQL Server Import and Export Wizard)
Is there a limit on the number of tables ? (we didn't have this problem with SQL 2000). Is this related to
http://sqljunkies.com/Forums/ShowPost.aspx?PostID=10717
Any help will be appreciated. Thank you!
SG ganinos_at_sat_dot_com
Hi,
I'm new to SQL Server 2005 Express and SQL. I've been using Access for year and have not moved on to asp.net for my website. I understand from 1and1.com that I will need to imort a backup of my SQL Server 2005 Express file to my on site database. I don't find any way to do that. Please advise as to how I get the express version to work on my site.
Thanks!
Leesha
table objects' indexes cant copy from source sql server db to target sql server.
pls advise how to enable indexes copying in SQL server Import & Export Wizard(sql server 2005).
regards
ym ho
I'm trying to export a SQL Server 2005 Express database to SQL Server 2000 sp4, but have so far been unsuccessful. SQL 2005 Express doesn't have an Export Data function and backup/restore doesn't work because of the different versions.
Any suggestions greatly appreciated!
Hi all,
Posted - 12/05/2007 : 01:54:18
How to export data from SQL Serevr 2005 Express to Excel 2007 using OPENROWSET command.
I have tried the following code But getting error
sSQL.Format("insert into OPENROWSET('Microsoft.JET.OLEDB.4.0','Excel 8.0;Database=%s;','Select * from [%s$]') select * from [%s]", sExcelPath, sSheetName, sTable);
But getting the following error
The OLE DB provider "MICROSOFT.ACE.OLEDB.12.0" for linked server "(null)" reported an error
I am using automation object for creating EXcel .I have added the header also.
Any help is appreciated
Thanks
Hi there,
I cannot seem to find a way to export a database model from Visio to Sql Server.
Can somebody provide a walkthrough how to export it?
Thanks a lot
Hi,Currently, I am developing an application for my client. The issue is that the client has the office and warehouse which are in different locations. He wants the application run and updated all the data in to a database (called warehouse database). Every month, all records in warehouse database will be synchronized to another database which is identical with the warehouse database but it is run in his laptop at the office. Since networking is not an option, I have to create two identical database like this. Does any one know what is the good solution to this? Is there any synchronize feature in SQL Server 2005?Many thanks,
View 1 Replies View RelatedI want to export data in a table from one database to another database. And I would like it bo be clone of the source table, if it's possible. Is there any tools out there that can help me with this or do I have to write my own code?Is it possible to query the database to get all columns and datatypes for å requested table? If possible, can you give me an example?If I have to write a tool myself I guess I would do something like this: Export - Query the database for columns and datatype for the requested table. Dynamically generate a query to retrieve all rows from the table and save it to an xml file. Import - Turn off the Identity Increment, loop through the xml file and generate insert queries to insert a clone of each row, turn off the Identity Increment. Viola! If programming only could be that simple :-) Regards, Sigurd
View 5 Replies View Relatedi am handling a project where user can choose the excel file and the field in the excel file to export into sql server 2005. which mean there will be dropdownlist where the user can choose the field and so on. anyone know how to do this?
View 2 Replies View RelatedI have to export data from SQL Server 2005 express to Access database. I have done many import/export using DTS package via SQL 2000. I don't have BI installed in my SQL SERVER 2005 Express. I understand that I have to use SSIS for sql server 2005. Any help is greatly appreciated.
View 1 Replies View RelatedHi,In SQL 2000 if I wanted to take a complete copy of another running sqldatabase all did was create a new database locally and right-click itand select import and point to another database and click copyeverything (stored procedures as well) and it did it for. I can't seemto find the same functionality in SQL 2005. You can copy tables andviews but not the whole database. Is there another way of doing this?Our SQL database is hosted externaly and they recommend using theimport/export feature to do it. Does anyone know I can copy everything(such stored procedures, data table relations...etc)TanksMA.
View 1 Replies View Related
Hii
I want to transfer data from table to a text file.I m trying to use bcp utility and xp_cmdshell.but the export is not successful.
My query is:
EXEC master..xp_cmdshell'bcp "Select * from test..emp" queryout "c:dept.txt" -c -T -x'
and its output is:
NULL
Starting copy...
NULL
3 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 16 Average : (187.50 rows per sec.)
NULL
but there is no row copied into c:dept.txt
where is the problem??
Thanx
-Supriya
Hi folks,
I have a question, which is that i currently have records of Chinese characters in (Free text) which i need to extract and export into Sql Server 2005 data. How can i automate this using Sql SSIS package. I have photos also need to export to.? If i manage to export out , how can i view it in the table?
I need to transfer dbf file to sql server 2005 express edition with some periodic interval. Can any one please recommend which is the easiest and efficient method to do?. Like polling every 5 to 10 seconds transfer data to sql server 2005 ex edition.
Is it recommend to do it visual basic program?, how to do it. pls help
Hi, i want to back up my SQL Server database and the cubes i've made on the anaysis services
i have backed up the SQL server database wihtthe wizard, and i do not know how to back up the cubes..
Is it possible, and if so, HOW??
thanx
reply @
nouman@emirates.net.ae
we are using ASMCD to sync our cubes from a Cubebuild Server to a Reporting Server. We migrated some days ago from 2012 to 2014. We are also using rel. Engine with StoredProcs for calling and executing xp_cmdshell for the Ascmd.Actually all works fine for our smaller cubes. For the bigger one we got the following issue. The cube is being synced but the proc delivers error.In the log we found this entry:
(7/7/2015 11:26:22 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.dbLocal Controlling Cube.0.cub' could not be deleted. Please check the directory for permissions.
(Source: ?D:SSAS_LOGmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210020)
(7/7/2015 11:26:34 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.db' could not be deleted. Please check the directory for permissions.
[code]...