Answer Questions

• Abhijitkane accesing cube from java

  Hi, I am new to Analysis services. i need to generate the reports using the data in cubes by java.. can any one tell me how to access the data in cube using java... is there any article for this.... Thanx in advance.. Ashok Hi, A possible way would be XMLA. Here you can find the details: http://www.xmla.org Christian Hi, I am also new olap cubes and analysis services, Please t ...Show All

• element__ Error Installing Workstation Components SQL 2005 Enterprise

  Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is: EventType: sql90setup P1: installtoolsaction P2: 0xc0000006 P3: 0x78158a35 P4: 0xc0000006 P5: setup_sqlactionenginelistener.cpp@198 P6: setup.exe@2005.90.1399.0 P7: none This happens after the second disk of the installation is about halfway throug ...Show All

• Pietje_Gates Programming Subscription Options

  Hello, We are developing our own ASP.NET 2.0 (C#) front-end for Reporting Services.  We are trying to create an interface for setting up standard subscriptions that is similar to Report Manager. On Report Manager's Report Server File Share options page, there are two options Render Format and Overwrite options that we need help with.  Can we query the ReportServer and get the available Render Formats to populate a dropdownlist   ...Show All

• Rick Heiges Trim or ignore extra carriage returns for Flat File Source

  the incoming txt has some extra carriage returns.  How can I tell the flat file Source component to just ignore or trim those....because the component fails when it comes across them. Example, the txt file has: asdfsf,dfdfd,dfdfd,dfdf,dfdfd,fdfd asdfsf,dfdfd,dfdfd,dfdf,dfdfd,fdfd asdfsf,dfdfd,dfdfd,dfdf,dfdfd,fdfd ----get rid of this blank line or else my component fails! ---- asdfsf,dfdfd,dfdfd,dfdf,dfdfd,fdfd asdf ...Show All

• CSharpDavid adding a new data column (not derived) midway thru a data flow

  I need to know what a table's max row Identity is part way thru a data flow.  I can't get it at the beginning of the data flow.  I need to either (1) add it to the data buffer part way thru or (2) set it into a package variable and then reference the var in a script component. I've not found a way to add a database column to the data buffer without doing a lookup for each row (too slow and not appropriate here) ...Show All

• Erik Almquist How to create and combine 4 reports, one being a total off fields from the other 3 ?

   If I have one rdl.. and I need 4 reports in it, one has a table that is a summary off certain fields from the other 3.  I have some questions then 1) How do I add 4 reports to the same report so that I end up with 4 Excel tabs 2) How can I relate a 4th report to be a summary report of all 3 other reports in the same rdl  My Excel file in the end will have 4 sheets.  3 of them will be reports, and the ...Show All

• vrok137 “AcquireConnection method call to the OLEDB Connection Manager for SQL Server failed” Error

  I have an SSIS package which takes input from Flat file and transfer the data to SQL Server using OLEDB Destination Data Flow Item. The OLEDB Connection Manager used for the destination is configured to use SQL Server Authentication for the user ‘sa’. The package works fine without enabling the configurations. But when I enable package configuration and save the configuration of the various connection managers in an XML configuration file and t ...Show All

• Salmec are you sql god???

  Hi all, I need the time that a stored procedure was created/altered. In sysobjects table, creation date of the stored procedure is logged. But if the stored procedure is altered this column is not updated. 1. Is last alter date of a stored procedure loged somewhere 2. If not, can I restrict users to "alter procedure" but not "drop/create procedure" so that they will have to drop and re-create procedures so sysobjects.crdate will ...Show All

• depp Can you create an Alias in a Data Source View?

  Hi All.  I'm building a report model for the first time (SQL Server 2005 June CTP).  I created a data source view by adding the tables that I wish to have in the model.  Now I want to use one of those tables more than once, but I don't see a way to create an Alias.  I see that I can create a Named Query, so I could use that, but I'd rather have an Alias for performance reasons.  For example:  Let's say you have a Fa ...Show All

• Sandy K. Cannot connect to remote SSRS instance with SSMS

  I recent installed a named instance of SSRS 2005 on a remote server. The server has a side by side install of SSRS 2000 and SSRS 2005, with the SSRS 2005 being a named instance. The server also has SSL and MS Sharepoint Portal Server installed. When I try and connect to the SSRS 2005 instance with my client install of Mangement Studio, I get the error message: "The underlying connection was closed: Could not establish a trust rel ...Show All

• highpockets Task Expression Evalutation Time

  I have designed a package whose first step initializes several variables .  Other steps in the package have expressions based on those variables. Example Expression for MyTask:    PropertyName = "Disable"    Expression = "@DoMyTask" Given this example MyTask will be enabled/disabled solely based on the value of @DoMyTask at the time the package execution begins.  Changing the value of @DoMyT ...Show All

• Matheesha Query behaviour

  Hi there, I wonder if one of you worthy folks can help me out with some strange behaviour exhibited by a piece of SQL. Its my first post here , so please be gentle. Here is my simple example :- <my test table> create table test (ind int, message varchar(255)) insert into test (ind, message) values (1,'date=01/06/2006') insert into test (ind, message) values (1,'date=20/12/2005') insert into test (ind, message) values (2,'test') The fir ...Show All

• Alex Feinman Using ALTER ASSEMBLY to refresh the bits of an existing assembly

  According to the documentation , it looks that it's possible to use ALTER ASSEMBLY to change the contents of an existing assembly: "If the FROM clause is specified, ALTER ASSEMBLY refreshes the assembly with respect to the latest copies of the modules located at the network location you specify." However, if I execute: CREATE ASSEMBLY [MyAssembly] FROM '\\mymachine\Test\MyAssembly.dll' ALTER ASSEMBLY [MyAssembly] FROM '\\mymachine\ ...Show All

• NotaProgrammer Error doing "Process Update" on some dimensions

  When processing some of the dimensions in my database using "Process Update" I get an internal error from the OLAP Engine (no specification)... Any known bugs on this, or am I just missing something Having gotten some new information from Microsoft, I am quite certain that this is a bug. Microsoft should be aware of it, and a fix will hopefully make it into SP1. Can you post here bit more information about your situation: ...Show All

• Windrider67 Cross Package Configuration Files

  Configuration files are working great for me when I run a package "stand-alone". However, when one package executes another package I am having problems. Assume the following two packages (each having connection info in a config file): foo (with connection A - contained in foo.config) bar (with connection B - contained in bar.config) The package foo executes package bar. Where would I have to modify the connection information for connection B, s ...Show All