Answer Questions

• Nick Colebourn Analysis Services on SQL2000 SP4

  "unable to browse the dimension [dimension name]. Provider cannot be found. or Unknown Error. Everything else looks good, like processsing, looking at the tables,fields, datasource is connected. Dear, Did u used a shared dimension in the cube. from sufian Can you please describe your situation in bit more details. What version of Analysis Services you are using What relational database are you using What OLEDB provider What is the exact error message you are getting and at what stage Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. Are you talking about SP3 or SP4 The title suggests you'd like to install SP4. Is that so Please make s ...Show All

• vtortola Unable to update table with Access Front end

  I have an sql table that will not allow me to update it with and access front end. I have another table in the same database with the same permissions that allows me to update. Both tables have an key column. Any ideas The table key did not have identifier checked off What error do you get Perhaps there are constraints, non-null columns etc. that prevent the insert ...Show All

• jeremy2006 problem

  Dear All, I have tryed to insert a textbox in an SQL Server Report. With normal text it is easy to show the text from an access database with the help of a dataset in the report. But in my database I have text as RTF. Is it possible to show the formated text in an Report Hopefully anyone have the answer or an idea how it is possible to show rich text formated text in a report. Thanks stefan   Dear Fang, do you know a date when the feature is finished Is it in the near future, or could it takes several month Should this feature include in an free service pack or should it be a new version with additional costs Where could I find the i ...Show All

• isaacb Delay in package starting when running from SQL Agent

  Hi, I wonder if anybody can shed any light on this problem. I have a SQL Agent job which has three steps, each step runs an SSIS package. The job is scheduled to start at 11.00 pm, which is does successfully. However, it has been taking between 2 and 3 hours to run, which is way longer than it should. When I've looked at the logging, I've found that the although the job starts at 11.00 pm, the first package (in job step 1) does not start executing until about 11.30. It finishes in about 5 minutes, there is then about an hour delay before the second package (in job step 2) starts. This finishes in about 10 minutes, then there is another hour delay before the third package (in job step 3) starts. I've tried configuring the steps ...Show All

• ganesh.p Browsing cubes through interfaces other than the BI Studio?

  I've built a cube, deployed it and processed it. I can use the brower in the BI Studio to see the data subsets and can manipulate it. How do I get this cube to the user without having to install BI Studios on their computer Basically how do I get the cube into IIS so the user can just open a web browser and go to it Similar to how cognos does it with their cubes. Or is this not possible I see no way to view the cube unless you are using the BI Studio to open it. Am I missing something Take a look at this one: http://www.beyond2020.com/products/vista_overview.php For a demo: http://www.beyond2020.com/products/demo.php Could you point me to some documentation o ...Show All

• Rudemusik SQL 2000 Enterprise Linking of servers not pulling data.

  I know this is an easy one for most of you but this is new territory for me. I am trying to link a production application database to an existing SMS database. Both of these databases are SQL 2000. I have sa access to both of them. I have an accreditation application that deals with internal processes within our active directory network. We are using SMS database collections to provide the discovery for reporting of this application database and I want to compare the collection to the existing data between the 2 databases. For simplicity I will define them both. Application Database we will call “A-Database” SMS Database we will call “B-Database” I have gone into the A-Database and gone to linked Serve ...Show All

• Blast two dimensional array using form designer

  How can i create a two dimensional array within a form using the form designer. I think you're probably looking for the .NET DataGridView control. See http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridview.aspx for more info. Hope this helps, Steve This is in visual c++ form creation using the form designer. I want to create a form with five 4 byte fields across and four rows going down. Moving to tools forum. I am talking about a screen painter in visual c++ (form designer). I might be in the wrong forum. This has nothing to do with SQL server. I just want a simple two dimensional array on a screen (form). My be i am not speaking the r ...Show All

• Boulderdude Percentage/Proportion

  I'm new to Analysis Services 2005 and MDX. I'm trying to create a calculated member that contains the proportion of cases (using [Measures]. ) for each dimension in the cube. The following code gives me the percentage of the total number of members in each dimension. This is what I need for attribute hiearchies (single-level), but for user-defined hiearchies (multi-level) I want the percentage of the above level. For example, in a time dimension, I want the proportion of cases in each year (this works) and the proportion of cases in each quarter of a given year (this doesn't work). CALCULATE ; CREATE MEMBER CURRENTCUBE .[MEASURES].PercentCases AS CASE WHEN IsEmpty ([Measures]. ) THEN NULL ELSE (( [DimLocati ...Show All

• anu_ooo Cannot fetch a row from OLE DB provider "BULK" for linked server

  I have an SSIS job that is pumping to a SQL Server Destination, hundreds of gigabytes of raw text files. Today I received this strange error - does anyone have insight Also, how would I make the data tasks more stable and robust so that this doesn't cause package failure (retries, or something ) [SQL Server Destination [4076]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The OLE DB provider ...Show All

• Blast possible to access postgresql from sql server ce

  I am wondering if it is possible to access a remote postgresql database using the sql server ce access classes. I do not want to run a postgresql server on windows ce, just access one from a mobile device. Spasiba No, you can not. As name implies you can only access SQL Server CE with SQL Server CE access classes. Thanks for your reply. I guess the real question I have is: Is there any way to access a remote database that supports ODBC using Windows CE and Visual Studio .Net After doing a little research based on what you said I would need, I did find a beta OLEDB provider for postgresql http://pgfoundry.org/projects/oled ...Show All

• TaDa Partitioned View Pruning Issue

  I'm using Sql Server 2000 Standard Edition, service pack 3. I'm fairly new to partitioned views and merge replication. We have a 3-year set of monthly tables with about 1 million rows per table from some code we inherited. To ease development , I'm trying to create a local partitioned view. We wanted it to be UPDATE-able and be able to select data by a date range or by id without incurring very much cost. The problem is that my SELECT statements correctly prune the unneeded tables while my INSERT, UPDATE , and DELETE statements do not. Here's our basic structure: CREATE TABLE [dbo].[Call_2004_01] ( [id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [callStartedOn] [datetime] NOT NULL , [rowguid] un ...Show All

• robertje Report updates not Saving

  Hi, I have a problem when uploading changes/ new reports to the report manager. I can get to the upload file screen, I can even browse to the .rdl file that I want to upload, but then the "OK" button seems to be disabled. I cannot seem to get the Report manager to accept any new reports or changes to the old ones. I have System Administrator access and everything was working perfectly untill about a week or two ago, no changes were made that I can see. Please help! See this tread. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=173608&SiteID=1 ...Show All

• mchagers How can we manually change the scales displayed on ProClarity Perspective Views?

  Hi, all here, Thank you very much for your kind attention. I still think here should be an ideal place for me to put my post here for help for ProClarity (with SQL Server 2005 Analysis Services) Would please any expert here give me any guidance and advices for if it is possible for users to change scales displayed on ProClarity Perspective views And if it is possible, how can we change it Thanks a lot in advance for that. With best regards, Yours sincerely, Hi, Thomas, Thank you very much. With best regards, Yours sincerely, You cannot change the scales of the y & x axis in Perspective. What you can do is right click on an interesting part of the tool and choose zoom/zoom out. The sc ...Show All

• orouit Regular Expressions in SQL 2005 using C#

  Hi all, i wrote a little function that is basically supposed to give me a match of a regular expression in C#. i tested it out in VS05 and it seems to work fine. It hits the fan when i try it on SQL Query analyzer once deployed. Anyone have any idea why here is the C# class that I deploy to a db using VS05. using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using System.Text.RegularExpressions; public partial class RegExTest { [Microsoft.SqlServer.Server. SqlFunction (IsDeterministic = true , IsPrecise = true )] public static string RegExMatch( string pattern, string matchString) { Regex r1 = ...Show All

• perrs intercept pipeline events programmatically

  Hello, I'm wish to receive pipeline events fired by a SSIS package. I execute the package successufully with the following code (c#): MyEventListener eventListener = new XplorerEventListener(); DtsApplication app = new DtsApplication(); Package pkg = app.LoadPackage("c:\test.dstx", null); pkg.Execute(null, null, eventListener, null, null); MyEventListener is inherited from DefaultEvents, overriding all OnXXX methods. It works perfectly, however I cannot intercept the following events: - PipelineExecutionTrees - PipelineExecutionPlan - PipelineExecutionInitialization - BufferSizeTuning - PipelineInitialization Anyone knows how to catch those pipeline events TIA, Paolo. ...Show All