Answer Questions

• Jacky Yau Drillthrough with Return clause

  I am trying to perform a drillthrough with the return clause so that i can get the member keys. when the performing the drillthrough, i get the followin message: Errors from the SQL query module: The 'dim peiod' table either does not exist in the 'Dm GL' schema (or cube.), or the user does not have the necessary permissions to access it. I've dumbed down the query as much as possible i think - and it works fine without the return.... drillthrough maxrows 10 select {[measures].[amount]} on 0, {[dim acct].[account]} on 1 from [dm gl] return [dim peiod].[month] thanks much, sully I have 2 suggestions. Are you sure the name is spelt correctly Is the ...Show All

• rwerner BCP taking very long time.

  I have a table which has near 50million records. The .dat file created by BCP queryout is of around 51GB. I am forming the BCP queryout and BCP IN commands in a stored proc and executing the same using xp_cmdshell. I am using the below BCP options : / T / b60000000 / a16384 / w / t}@ !{ / r} ^ #{\n / h"TABLOCK" With above the QueryOut is taking around 8 hrs and BCP IN another 10 hrs. These figures are not very healthy. The database recovery mode is set as simple. Server config: Windows server 2003 X64 edition, with 16 gb RAM. Any pointers on what could be the reason for this The table structure is as below: CREATE TABLE XXX.dbo.ZZZ ( A nvarchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS ,B nvarchar(15) COLLATE SQL ...Show All

• microsoft_programmer How to create a report using multiple databases

  Hi, I am a beginner of Reporting Service. I am trying to create a report using multiple databses. For example, I want to create a report called RevenueByCustomer, so I need to get data from the Customer Table of CRM database, which contains customer information, and I also need to get data from Transaction table of Sales database, which contains all the revenue information. In order to get data from both database, I have created two dataset. One is Customer dataset, which get all required customer data from CRM database, and the other is Revenue dataset, which gets data from Sales database, they used seperate datasource (because each datasource only contains one database connection). Now my problem is how can I make them be displayed in on ...Show All

• pdurbha SSIS Syntax issue

  Hello Can someone show me what I'm doing wrong with: C:\\FolderName\\"+ @[User::varName] +".xml Error at Data Flow Task [XML Source [1]]: The component "XML Source" (1) was unable to read the XML data. Error at Data Flow Task [XML Source [1]]: There was an error setting up the mapping. Pipeline component has returned HRESULT error code 0xC02090D0 from a method call. (Microsoft Visual Studio) Thanks Worf If this is used in an expression I would say that the right syntax is:   "C:\\FolderName\\"+ @[User::varName] +".xml"  Rafael Salas ...Show All

• Mnd1 Unable to read local eventlog (the parameter is incorrect)

  In trying to setup alerts and activating them, an error occurs in the sql agent log of Unable to read local eventlog (the parameter is incorrect) The full messages from the Windows NT Logs shows: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 318 Date:  03.11.2005 Time:  17:14:47 User:  N/A Computer: RESYSHADOW Description: Unable to read local eventlog (reason: The parameter is incorrect) Does anyone know what could be causing this.   I have tried it on Windows XP SP2 with local Admin account and on Windows Server 2003 with Domain Administrator Account and the SQL2005 Server is RTM with the same results.   I'm also ge ...Show All

• ifaber Installation problem

  I have installed SSRS 2005 in one system.There is only configuration tools. But there is no SQL server Business intelligent development studio,SQL Server Mangement Studio and Performence tools. While I am installing I am not getting this problem in all machines. Please help me Do you have SQL Server Express installed If yes, you will have to download the tools that don’t come with the default package or download the Advanced Services ediotion: http://msdn.microsoft.com/vstudio/express/sql/download/ HTH, Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Thanks Jens ...Show All

• Toolz Changing the caption of a member name in a Named Set

  I have created a named set that includes a list of five customers. One of the customers is named "XYZ Corp.". For the named set, I want to display the customer with a name of "XYZ Corporation". Could someone supply me with the syntax needed to do this Thank you. David Normally it is not possible to change captions/names of the existing hierarchy members. The usual workaround is to create calculated member which aliases the original member. This, however, has couple of implications, for example Exists rules for the calculation member are different etc. CREATE Customers.[XYZ Corporation] = Customers.[XYZ Corp]; CREATE SET NamedSet AS { ..., [XYZ Corporation], ... }; ...Show All

• apunater Bulk Insert fails. Column is too long in the data file

  Hi, for testing purposes I'm inserting a flat file into a sql-server table using BULK INSERT unsig the following code: BULK INSERT rsk_staging FROM 'c:\temp\bulk\rsk.txt'   WITH (     FIELDTERMINATOR = '\n',     ROWTERMINATOR = '\r\n',     CODEPAGE = 'RAW',     DATAFILETYPE  = 'char',     BATCHSIZE = 100000,     ROWS_PER_BATCH = 1925604,     TABLOCK   ) I have two versions of "rsk.txt" one with 1.9mill rows and one with the first 2000 rows only. The files have one column only with 115 characters that I'll split in to several columns later using SUBSTRING. The one with 2000 rows fires in to the database with ...Show All

• Amit Vyas error in ssis package!

  Hi, [OLE DB Destination [1146]] Error: An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict". [DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1146) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009. have any of u encountered this error package is wo ...Show All

• REspawn Mdx Function to get Descentants until a specific level is reached?

  Hi, I have a parent-child dimension in wich i need to analyse data only to a specific level... Imagine that my dimension have 10 levels but i only want to get the hierarchy to reach the level number 3.. So it would be in the report like this: Level0 Level 1 Level 2 Level 1 Level 1 Level 2 Level 3 Best Regards, Luis Simoes True, you get the level names in a Parent Child dimension. However, if you just one the first 3 levels you could just use: descendants ([Dimension].[All Member Name],2, SELF_AND_BEFORE ) Santi I may be wrong but I think AS does give the levels names in a P-C dimension. Unless you change the default I think they are calle ...Show All

• windoze SQL Server 2005 Evaluation and SQL Express side-by-side?

  I have SQL Express installed on my desktop and want to install SQL Server Evaluation. Will these 2 clash or can they sit happily side-by-side I'm getting the below error when trying to install evaluation on a machine running Express already. I don't want to upgrade, I want a seperate installation. Any help appreciated. I have been looking at the Books online, but don't see much of anything other than that there is no upgrade path from express to evaluation, but I don't want to upgrade anyway... Name: Microsoft SQL Server 2005 Tools Express Edition Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Sof ...Show All

• RajLakamana Matrix - How to calculate % of row?

  Hi, I wish to create a matrix with multiple rows in the main data cell and a subtotal at the end of the row. The first row in my matrix main cell is just a count of records, whereas the 2nd row is a % of the value in the 1st row compared to the total of that row. I have 5 columns in the matrix as below (ignore rounding issues): Status A B C D E Total 01/01/2007 Number 9 32 3 13 0 57 % of Total 15% 56% 5% 24% 0.00% 100.00% Can someone advise the best way to calculate the % cells in this example Thanks Thanks for the response Mr.rajz I had to change the query at source as I was not using SSAS. ...Show All

• MollieRosen Looking for a randomize function

  Hi everyone, Primary platform is Sql2k I'd like to have available a function which retrieves a random row. Does anyone have ever used or faced this requirement Thanks in advance for any input or advice Try ordering your resultset by NEWID() to see if this meets your requirements. i.e. SELECT TOP 1 * FROM MyTable ORDER BY NEWID() Chris It was useful for us. Thanks for that. ...Show All

• Coder0xff Creating Graphs in access on a click of a button

  I need to create graphs in access in a lick of a button all the data will be in the sql transfered from the access. If anybody did this before ar having Idea please let me know It's not too difficult to do this because there is lots of Wizard help. First create a linked table to the SQL Server table from your Access database. Then use the Form Wizard or Report Wizard to create a chart using the linked table as the source of data. I was talking about the Report Wizard in Microsoft Access. SQL Server does not have a report wizard. For SQL Server, you want to investigate installing SQL Server Reporting Services, it will let you create very nice reports inside Visual Studio against SQL Server. may I know where can I find ...Show All

• Michael.Young Cannot set Connection property of Backup database task if connection string is customized in connection object

  I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string. Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value. Then after spending several hours I found that this is because I have customized t ...Show All