Answer Questions

• Business Intelligence Analyst Command line/utilities to clear cache

  Hi,Does Reporting services expose any command-line or utility tools to clear reports cache explicitly other than the caching configuration at certain interval Thanks,Jet You can find information about scripting here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsuiref/htm/cpu_rs_v1_5fxe.asp You should also look at this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_prog_soapapi_script_3249.asp The flush cache method is here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_22i9.asp You script will look something like this (not sure this is 100% correct) Public Sub Main() Dim ...Show All

• FSchmid Does Debug > Build in Script Task actually do anything?

  I'm looking for some way to verify the syntax, references, variables, etc. in my Script Tasks without having to run the package or the task. There's a Build command in the Debug menu, but it doesn't seem to do anything -- certainly, not like the "Build Solution" in a Visual Studio project. Am I missing something Does Debug > Build in the VSA editor actually do anything Thanks! - Mike mike.groh wrote: I'm looking for some way to verify the syntax, references, variables, etc. in my Script Tasks without having to run the package or the task. There's a Build command in the Debug menu, but it doesn't seem to do anything -- certainly, not like the "Build Solution& ...Show All

• chrisc12345 sending mail to several users with Send mail task ?

  I know you can specify additional recipients in the To column by sepperating them with a semicolon. But whats the easiest way to send to several users, when the email address must be retrieved from a table with a query like this: select email from problem_subscribers where project = 'project1' and statusmail = 'OnError' So when the eventhandler gets an OnError i want the mail task to be sent to each problemsubscriber. Use SQL Task to get a recordset and then loop the record set using For Each Container. For each container will have Send Mail task. Use the expression editor of send Mail task to set the properties of send mail task Here's what i did: Using Execute SQL Task, run ...Show All

• kcabral1 Connections to SQL Server Files (*.mdf) require SQL Server Express 2005

  When ever I click on an MDF file in VS2005 I get the following message. Required Components Missing. Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly.  Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/ linkID=49251. I think this may have been due to the install order and options I selected. 1. VS2005 Pro, without SQL Server Express 2005 as I was planning to install SQL2005 Developer. 2. SQL2005 Developer. I then noticed the above problem and installed SQL Server Express 2005 from the VS Pro DVD.  I still have the problem.  Any ideas how I can fix this I have VS2005 developer and then install ...Show All

• olive2 Got BIDS working, was there another way?

  i re-installed the SQLEXPR_TOOLKIT.EXE several times(4) trying to get the BIDS part to work. Each time i had the issue of it looking for the devenev.exe as others have mentioned. I gave up on a 5th install and went for the unsupported option of running vs_setup , after the toolkit.exe dumped all the install files to its temporary directory i went in there and ran it sperately... but essentially i did it the same way as this method... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=368549&SiteID=1 while this did work, it seems to be the unsupported way. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=665067&SiteID=1 Im not opposed to going back and doing it right, but was there ever a conclusion as to why the BIDS prog ...Show All

• John.Doe Comparing dates

  HI, In my report there are two parameters,One is for StartDate and One is for enddate.Startdate must lessthan enddate.How to compare two dates in sqlserver report,and if send date is earlier than startdate how to display error message. Thanks in advance You can use the expression as the value of a textbox where you want to display the comparison result. You can use the Parameters collection to reference the value of a parameter - Parameters!StartDate.Value. So you can compare the two dates like =IIF(Parameters!StartDate.Value > Parameters!EndDate.Value, "Error", "OK"). Hi, where we have to write that iif condition.Please help me. ...Show All

• donna123 Size of the cube

  Hi, Can anyone please let me know how can I get the size of my cube. I need to check out the disk space occupied by the cube. Thanks You can sum all the EstimatedSize values (bytes) for the MeasureGroups of a Cube (they are estimated because for ROLAP they don't include the size of the tables in the relational database). Adrian Dumitrascu Hi, I have already processed my cube and I need to know size occupied by cube on disk. Its MOLAP cube. Does Metadata tab in Analysis manager shows proper cube size or do I need to do anything else ...Show All

• David Guyer MSFT Design/load question

  Hi. I am redesigning a database to be more normalized. There are 4 columns that appear in many of the tables that I plan to add to a new table. Here is what the database looks like now: table1 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. table2 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. table3 uniquecolumn1 uniquecolumn2 uniquecolumn3 samecolumn1 samecolumn2 samecolumn3 samecolumn4 uniquecolumn4 etc. If I add a 4th table with the columns that are the same in each of the tables, I'd have this: table1 uniquecolumn1 uniquecolumn2 uniquecolumn3 uniq ...Show All

• chionhhm problem with job

  hy, i have made a package that fills a sql server 2005 database. when i run it locally it runs all the way, no errors. Now that i have deployed the package en work with a job that executes it every day i get these errors. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. and component "Source - BU" (1) failed validation and returned error code 0xC020801C. the strange thing is i don't get an error on the first dft which uses the same connection. i have pressed the test connection button and it states connection succesfull. any help would be appreciated. Greetz, Jens Are you by chance running the ...Show All

• hrubesh Reporting Services Failed Install

  Hi all, I have an SBS server that I tried to installed SQL Server 2005 Express edition for some testing/dev work (non-production server here) and although SQL installed, the reporting services component failed with the following. -------------------------------------------------------------------------------- Machine : RAND Product : Reporting Services Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation. -------------------------------------------------------------------------------- Machine : RAND Product : Microsoft SQL Server 2005 Reporting Services Product Version : 9.1.2047.00 Install : Fail ...Show All

• Perry_Rapp Proceesing cube using analysis services processing task

  Hi, I have a dts package stored in sql server 2005 which has a analysis service processing task to process a cube stored in sql server 2005 itself. whenever i try to execute this package it crashes the sql server management studio and in the logfile i can find the error operation has been cancelled . When i try to process the cube directly it processes without any problem and i can browse and see the data also. In the package i am trying to do full process of the cube. Also the cube and the package are migrated from 2000 to 2005. The onemore problem is after migrating the package i am unable to see the cube setting also Please help me to solve this Thanks in advance Mervin ...Show All

• Andrew Revvo SQL Server Management Studio remote server agent status

  I have seen posts related to this, but no solution for my situation. On a new Windows Server 2003 system running SQL2005 SP1 (9.0.2153), remote DBAs do not have a service status indicator in the object explorer in ssms. If the DBA logs on to the server locally using the same domain ID the appropriate green arrow/play sign indicator is displayed as expected. The DBAs are members of a domain group that is a member of Remote Desktop Users and a local SQL DBAs group. The SQL DBAs group has been added as a SQL login and assigned the sysadmin role. All sql administration functions appear to work otherwise. Using subinacl to grant the SQL DBAs group access to query service state on the MSSQLSERVER and SQLSERVERAGENT services did result i ...Show All

• laurin1 Remote connection failed, even with proper configuration

  I am unable to connect to a SQL instance on the server from a workstation on the same network. SQL Express SP1 is installed on the server, and allows mixed authentication. The instance name is <SERVERNAME>\SQLEXPRESS. Both the Database and Browser services are running. Local and remote connections are enabled under SAC. I also used sp_configure to make the same changes. All Protocols for SQLEXPRESS have been Enabled using the Configuration Manager. The firewalls on both machines have been disabled. Rebooting the server or restarting services after various changes hasn't affected the outcome. Local connections made directly on the server are always successful using either authentication mode. SQL Native Cl ...Show All

• pappascd Procedure expects parameter which was not supplied...?

  I have this SP definition and below that the code to execute it from .Net. But I'm getting this error: Procedure 'GetNewId' expects parameter '@Key', which was not supplied. Saw an solution on some site which said to set the value of the output param to NULL before calling it, but that didn't do anything. Anyone have any ideas why this may be happening Thanks in advance. CREATE PROC GetNewId(@TableName varchar(32), @Key bigint OUTPUT) AS Declare @NextKey bigint BEGIN TRAN SELECT @NextKey = NewID from ID where TableName = @TableName IF (SELECT @NextKey)IS NULL BEGIN INSERT INTO ID(NewID, TableName) VALUES(0, @TableName) END UPDATE ID SET NewID = NewID + 1 Where TableName = @TableName SELECT @NextKey = NewID from ID where TableName ...Show All

• Big5824 positive and negative signs

  i have account_entries table which has the following fields: debit_or_credit entry_amount and I want when inserting every field to check if the inserted row was assigned to (D)ebit and (C)redit it should change the entry_amount accoridanly. maybe something like trigger plz help... Are you sure you want to change the value It could be better to have a calculated field like "case when debit_or_credit = 'D' then entry_amount else -entry_amount end as effective_amount" Rob I'm hoping I've answered your question correctly - I'm not entirely sure of the situation. Here I'm assuming you have revenue which is paid to you, but some people may have a discount, which reduces how much you cha ...Show All