Answer Questions

• MattWoberts OLAP calculated membres and Report Model/Builder

  My question is related to Report Builder but my data model is build using OLAP database so I am posting my question in OLAP group in case this issues is related to OALP side. I have OLAP database. There are 5 cubes and one linked cube. My one linked cube has mapped all 5 cubes (like virtual cube in AS 2000) I am using AS 2005. In my linked cube I have calculated members. I created a Report model using my olap database in reporting services. In report builder I am not able to see my calculated members when I select linked cube. Is there any thing I am missing Thanks for help - Ashok I think this may be related to whether the calculations are associated with a measure group. The Report Model on ...Show All

• shruti.makwana Creating a Linked Server to AS400 in SQL Server 2005

  I am trying to create a linked server in SQL Server 2005 to show tables in our AS400. I made the connection, however, the tables are not showing up under the Linked Server name. How do you get the linked tables to display in the Linked Server folder David Hi, thats correct, but this OLE Provider only able to install under the Enterprise Server. If you have the Standard server you can install it :-( But why Thank you MWendel I am trying almost the same thing. But I am not even able to create the connection to the server. I tried it like this: Provider: Microsoft OLE DB Provider for ODBC Driver Product name: IBMDASQL Data sou ...Show All

• Benin Spurious Errors With Package Execution on Local Machine

  I am having strange errors with a package when running locally that has not been an issue before. The main symtom is that several Data Flow Tasks are either not inserting records on the destination or are only inserting 1 single record before the package errors with the error shown below. Strangely, the debugger will show X # of records from source and destination, but either no records are actually written or, again, in many cases, only 1 single record is written. This is very strange. App, System and Security logs yield no indication of security or other errors. All I have to go on is the above anomolies and the error message provided below. Below is the error message, can someone help me decrypt it Many thanks, Rick ...Show All

• Alastair Q sql server 2000

  Can anybody help me................. what are the steps needed , as , the client connects to sql server 2000. Explanation: i test the connection thru normal tcp/ip client program , which is connected to sql server listening at 1433. SO, 1.How can i pass commands to access the data base at server side. 2. programming steps needed at the client side. 3. steps needed at server side sorry, its not clear what you are asking. Are you having troubles accessing data in a SQL Integrations Services package from a SQL 2000 DB ...Show All

• Mykhaylo Blishch Sql server install problem

  I am planning to work with replication topic and i have a problem with it. I have installed a SQL server 2005 standard edition.When i try creating a new publication it comes out with this error "Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of sql server. for information about installing replication,see installing replication in sql server books online Additional information: Execute permission denied on object 'sp_MS_replication_installed",database'master',owner'dbo'. (Microsoft SQL server ,Error:229) I have tried inserting the CD and reinstalling it.but didnt work. When i tried to Remove sql server from control panel ...Show All

• Magnus Müller Query much slower on 2005 compared to 2000

  We have a database developed using SQL Server 2000. We are in the process of testing it on SQL Server 2005. So far i've not done much testing but it has become apparant quickly that quite a lot of queries are performing much slower in SQL Server 2005. I am currently trying to figure out why a particular query is not performing well. One SQL Server 2000 it runs in around 6 seconds. On SQL Server 2005 it takes around 50 seconds. The query is this... SELECT StartBase, StartPoint, PickupPoint, PickupInstructions, SingleJourney, Destination FROM vwJobs WHERE StartDateTime BETWEEN '2006-09-01' AND '2006-09-23' vwJobs is a view in our database. The view includes many UDF's and also has a UNION which combines two seperate table structures ...Show All

• leclerc9 Delte from 3 table in one procedure

  HI I have 3 table in table 1 i have a ID i use in table 2 and in table 2 i have a ID i use en table 3 In table one i have a datetime field What i want is to delete all from this 3 table when the datetime value are more than one hour old. I can delete old from the table one by: delete from tableName where datettimeField < dateadd ( hour , - 1 , getdate ()) But how do i delete all the records from table 2 and table 3 off course where the ID in table one are the same as in table 2 and the ID in table 2 are the same as in table3 Hope someone can help LN Hi Thank again I have done it in the rules for the diagram But i have another problem with the same delete This is al ...Show All

• KSJP Select All = no Result

  hey there I have parameters in my report set up CallStatus = string Available Values are non-queried and values are listed in the value list closed, open, pending, select all If I choose each one separately I get a result - if I choose select all I get no result. This worked fine attaching to another datasource - I have now attached it to a new source. Tried altering the relationship to properties to a left outer join but this made no difference. Can someone tell me what else I should check thanks sorry guys as mentioned I am transferring all these reports to a new normalised database and missed a line as I said it worked fine and why it didn't transfer over properly I'm not ...Show All

• Eric66 Manual validation of external metadata

  Hi, is there a way to start validation of external metadata manual My problem is this: The package uses a variable as connectionstring for flatfile source, and another variable for the destination table. Running the package gives a warning about external metadata that needs to be updated. Normally I update this data by just opening the data flow, and answering the question for updating with yes. This time that deosnt work, I think because the variable is not set, so there can not be any conflicts with external metadata. I dont want do disable validation, but just validate one time and then save the package. Any ideas Regards, Jan Not sure I got the problem...but have you looked at th ...Show All

• Chris Coddington Deployment Failed

  Hi Team, Happy New Year to you all, When i try to deploy my project (SSAS Step by Step) with a calculated Member, the deployment fails. I actually get the following error. Error 1 The 'Database' with 'ID' = 'SSAS Step by Step ' doesn't exist in the collection. 0 0 When I try to change the transactional deployment property to true so as for me to overwrite the existing database i get the following error; Error 1 Members belong to different hierarchies in the function. 0 0 Could you please advise me on how to go about this. Any help will highly appreciated. Regards, Ronald Please provide the expression of the calculated member. From the error message it seems like you are trying to build a set from ...Show All

• Pockey SQL Server 2005 Workgroup Edition Licensing (How to install without a license, then require license on first run)

  I have a VERY Legitmate use to install sql 4 workgroups on a pc without licensing it. I am making a disk image for MANY pcs to be imaged and load licensing after the imaging is completed. I have been able to do this with Windows XP Professional, MS Office 2003 and a couple non-Ms programs. The information for MS software even came from their KB, so I know what I am doing is legit. I just can't find any information on doing this for my sql app. Any suggestions Respectfully, Frustrated "Frustrated" My suggestion would be to contact the vendor where you purchased your licenses and ask your questions to them. Thanks, Sam Lester (MSFT) ...Show All

• Yulia About @@ERROR in SQL 2005 online book

  Here http://msdn2.microsoft.com/en-us/library/ms190193.aspx it is explained that @@ERROR will be cleared and reset. But here: http://msdn2.microsoft.com/en-us/library/ms190248.aspx http://msdn2.microsoft.com/en-us/library/ms187009.aspx we still see: IF (@@ERROR <> 0) SET @ErrorSave = @@ERROR Chester Hi Chester, The second example is indeed incorrect as @@error will be reset to 0 by the IF statement. The local @ErrorSave should be set after each statement and them compared: declare @a int, @ErrorSave int; set @a = (1 / 0); -- divide by zero set @ErrorSave = @@ERROR; if (@ErrorSave <> 0) begin select @ErrorSave AS [ErrorNumber] end Cheers, Rob ...Show All

• Donaghy Deploying to Report Manager error

  I have created a report using SSRS 2005. It uses a stored procedure. It executes beautifully when I'm in reporting services. But, when I deploy it to Report Manager, this is the error I am getting. An error has occurred during report processing. Query execution failed for data set 'DataSource1'. An MDX Statement was expected. An MDX expression was specified. I have 3 parameters in this report. Start Date, End Date & Region. Region is a drop down that contains 2 options. This is a string field being passed into the procedure. Start and end dates are just basic date fields. I am not using a cube to get my data. I have deployed to the Report Manager before and have been successful. Thanks! ...Show All

• Shlizar Axis Flat File with Nested Data

  I am looking to import data into SQL Server 2005 using SSIS. I want to take data that is contained in a flat file and place it into the various appropriate tables in my system. The flat file contains nested data. For example... Bob,Smith,555-5555,123~3.33|245~1.99,Active So I want to build a package that brings in the records as follows Client Table: First Name, Last Name, Phone, and Status (Bob, Smith, 555-5555, Active) Order Table: OrderID, Amount (ID 123 @ $3.33 and another row ID 245 @ $1.99). If possible I would also like to tie the orders to the client record that was inserted. My first question is if SSIS supports nested fields as in my example. Can it break a file by commas, then within a field by other delimiters I ...Show All

• S.Mark Timeout and Audit Logout and sp_reset_connection?

  Hello, We've been getting some intermittent timeouts from our live website (the timeouts normally, but not always, occur when getting the user details - but that could be just because that task is happening the most often). However the strange thing is that this happens intermittently - but often enough to be annoying! I started a trace to see what was happening. I thought maybe it was a transaction/ or some sort of blocking SQL statement - however I'm not seeing anything that clearly indicates this.(I suppose the timeouts would only occur when another SQL was blocking the same db object, right And I don't think the updating of the user details are performed regularly.) However I did find some oddities that could maybe help: When we receiv ...Show All