Answer Questions

• barchard Aggregate function don't work with calculated measure.

  Hi, I can't get my AS2000 calculated measure to work with the Aggregate function. We are using Excel as our frontend for our cubes and Excel is using the Aggregate function when the user selects multiple items for a filter dimension. Here is the expression for my calculated measure: Sum({Descendants([Period].[Quarter].CurrentMember, [Month])}, IIF([Currency].CurrentMember.Properties("Fixed") = "1", [Amount Fixr], [Amount Flor]) * ValidMeasure([Rate])) I have tried different solve orders for the measure: -7000, -1, 0, 1. When I use solve orders < 0 I get following error: "The aggregate function cannot operate on measure ..." When I use solve orders >=0 I get an empty result set. An ...Show All

• Davids Learning High Availability and Scalability ...

  We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big. We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run. We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany. Or maybe database partitioning by language Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main ...Show All

• Jarret JOB With SSIS Step Fails If Package Contains A Script Task

  I have a Job Step defined to execute a SSIS Package.  This SSIS package contains a Script Task.  The Job fails with the message "Package execution failed.  The step failed."  I am logging events in the package and when the packages gets  to the Script Task the log reports "The script files failed to load".  If I disable the Script Task from the package it executes fine.  Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line. Only if I include the Package in a job step with the Script Task enabled does it fail. Any help would be appreciated. After settings Precompile to True, you need to open and ...Show All

• Perarg Can not create a connection to Oracle data source when report is processing

  hello, I am getting following error message when I try to view a report from reporting services. The report runs fine but after while i get the following error message. The error message will go away if i open the report manage from the server and run the report once. The report will run fine for a while from anywhere but afterwhile i get following error message. An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'OracleConnProc'. (rsErrorOpeningConnection) Error while trying to retrieve text for error ORA-12154 can someone please help me. Hello Robert, I followed steps from your suggested ...Show All

• EnigMa_AnGeL insert statement problem

  Hi all, I'm trying to calculate the data from one table and insert the results into another table. The queries are the following: 1. select top 5 userId, count(photoId) numOfPhoto from photo group by userId order by count(photoId) desc 2. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-30,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd,-8,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0))group by userId order by count(photoId) desc 3. select top 5 userId, count(photoId) numOfPhoto from photo where datesubmitted > DATEADD(dd,-7,DATEADD(dd, DATEDIFF(dd,0,getdate()), 0)) and datesubmitted < DATEADD(dd, DATEDIFF(dd,0,getdate()), 0) group by userId order by coun ...Show All

• Benke Problem in using USE dbname

  Hi, I am trying to monitor log and data space usage through dbcc sqlperf(logspace) and dbcc showfilestats commands on a server. what I want to do is to log all these for all the database using a cursor all work fine except User @db go inside the cursor body. Does anyone know any alternative to use this to what I want to get Thanks Ap I tried thsi it is printing but still not all the database are being looped it is just using the current active one so I need to do the USE @db to loop through all the databases and collect the dbcc sqlperf(logpsace) and filestats into a table. Any ideas where I am missing The problem here is that the USE @DB statement is only valid for the EXECUTE statement. ...Show All

• Goonie Transactions being rolled back and forward by DBCC CHECKDB - is this OK?

  Hi, I've set up some maintenance plans (SQL Server 2005) that include CHECKDB tasks. I'm noticing in the server logs that there are occassionally a few messages associated with the CHECKDB execution stating that a number of transactions have been rolled back or rolled forward. I'm worried that this might indicate potential data loss! But I hope this is just an indication of what had to be done to create the internal database snapshot used by CHECKDB. Is there anything to worry about regarding these messages "5 transactions rolled back in database 'XXXX' (15). This is an informational message only. No user action is required." "1 transactions rolled forward in database 'XXXX' (15). This is an informational mess ...Show All

• J9 .Net DataProvider for SAP Timeout

  I am using the .Net DataProvider for SAP. When importing data I receive an error, when calling sap functions via exec. The errors vary (e.g. Error 0xc0047062: Data Flow Task: Microsoft.Adapter.SAP.SAPManagedProviderException: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.) On the sap-side the function runs, but it takes a few minutes. I can ask the sap-bw team to speed up their performance, but this is political. The sql-timeout parameter is not working with this datareader. Have you any proposal that solves the problem. Thanks this is just a hunch: try using a smaller value for the DefaultBufferMaxRows property of data flow task. ...Show All

• Fritzenhammer Scheduling the SSIS Package to run after every 2 mins

  How can i plan the execution of a package For example, i want to execute the package every 2 minutes for all the time. I do not want to use SQL Server Agent to do this. I want the package to self contained to do it. Thanks Rohit You need to host your SSIS package, so DTEXEC is a great host, pretty much what SQL Agent uses. What else would you use to host it and get the schedule function If you have to launch lots of them that's a good idea make a application which throws SSIS on-demand using threads, wmi, and so on. I don't use SQL Agent either, but SSIS packages are not designed to be run like Windows services or Unix daemons. For one, there still is a memory leak in 64 bit (p ...Show All

• AlexBB decryptbykey multiple session issue

  Hi I'm having some issues using the decryptbykey method via multiple connections. When I run the below test script simultaneously on two machines the sum function is always less then the known amount (ie 14945490 and 36382777). Does anyone know of any locking method or alternative way to sum an encrypted column Thanks in advance Waz open symmetric key HR01 decryption by password = 'yes' DECLARE @Bonus decimal DECLARE @Salary decimal DECLARE @Errors int DECLARE @Success int DECLARE @LoopCount int SET @Errors = 0 SET @Success = 0 SET @LoopCount = 0 WHILE ( @LoopCount < 40 ) BEGIN SELECT @Bonus = SUM ( convert ( float , convert ( varchar ( 80 ), decryptby ...Show All

• Marcin_Zawadzki SSIS: Oracle import works, but not when scheduled

  Hi, I am running SQL Server 2005 and have built a simple SSIS package to import data from an oracle database to my SQL Server 2005 database. When I run it in SSIS, it works and it imports just fine. When I schedule it, it gives me problems. Help! It might be a problem with Oracle Provider client I installed. Is there a client version I can download and install the one I downloaded from oracle doesn't work. I bet i did something wrong though. Here is my version: Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447) Microsoft MSXML 2.6 3.0 4.0 6.0 Microsoft Internet Explorer 6.0.3 ...Show All

• Alexei_shk Confusion on Cube Design

  Hello everyone. I'm having a bit of trouble getting my head around designing a new cube and I'm hoping this forum can help. I have a database which contains the following simplified structure: tbl_Panelist: panelist_id tbl_Question: question_id tbl_Answer: answer_id tbl_Result_Set: panelist_id question_id answer_id I'm trying to design a cube which will allow analyzing of the counts of how many panelists answered each question by each answer. For example if Q1 has possible answers of A,B,C and Q2 has possible answers of X,Y, I'd like to be able to browse the cube and see X Y A 10 5 B 3, 2 indicating that 10 people answered Q1 with A and Q2 with X. My current thinking has been to create a ...Show All

• tanis15063 alter databse TestDB set TRUSTWORTHY on fails

  Hi all, When I try to execute the following command: alter databse TestDB set TRUSTWORTHY on I get this error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'databse'. Msg 195, Level 15, State 5, Line 1 'TRUSTWORTHY' is not a recognized SET option. Can someone tell me why Thanks in advance. Hi Madhu, Thanks for the quick response, but there is no SQLServer 2000 on my PC or my laptop. My laptop has Win XP and SQL Server 2005, and my PC has Vista Ultimate, with SQL Server 2005. The command was executed in Management Studio, which SQL Server 2000 does no have. Thanks. Standard edition. I see the "Trustworthy" o ...Show All

• furjaw RecordSet into a DataFlow Task

  In the control flow I have an "Execute SQL Task" that executes a stored procedure. The stored procedure returns a result set of about 2000 rows of data into a package variable that has been typed as Object to contain the data. What I have not been able to figure out is how to access the rows of data (in the package variable) from within a data flow task. There does not seem to be a data flow source task to perform that operation. What am I missing that would make this easy ...cordell... Cordell Swannack wrote: In the data flow task...I need to parse through the data to generate 3 unique result sets of data. One of the result sets will go to a text file, the 2nd result set go ...Show All

• M. Shariq Muzaffar cross server update problem

  The system has worked for two years. SQL Server 2000 runs on Windows 2000 Server “A”. Another instance of SQL Server 2000 was moved from Windows 2000 Server “B” old to Windows 2003 Server “B” new, by restoring a backed up copy from old to new. The system has cross server updates, where Server “A” is updating records in very large tables on Server “B”. After the move from Server “B” old to Server “B” new, suddenly the cross server updates fail, but only when they are conducted within a Begin and Commit Transaction batch. The system works when I remove the Begin and Commit Transaction, and no longer have them run in a batch. Also, I had a cross server update, having “A” update records in “B” ...Show All