Answer Questions

• ssauerw Multi Value Dependent report parameters help

  http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=343618&SiteID=17 In continuition with above thread i would to like to ask another question. Can we make Multivalue parameters to play for cascading parameters. I am trying with different combinations of using query parameters and Report parameters. Can any body help me Regards Raj Deep.A Hi, I've not tried it myself, but I think it should work. In the second (dependent) parameter, you should use the IN in the WHERE clause like: WHERE Region IN (@Country) Could you give a try Jordi Rambla MVP SQL Server (Reporting Services) Certia - rambla informatica ( http://www.certia.net ) Solid Quality Learning ( http://www.solidqualitylearnin ...Show All

• suneelpotluri using text file data in a SQL Task

  I have some fields in text file that I want to use in a SQL Task. What is the best way to read these fields and then plug them into the SQL Task Thanks Aref The text file include this line 20060721 through 20060725 This file is sent as a trigger that the daily production files need to be processed.                        I need to use the two given dates in the next delete SQL statement ad DATE_1 and DATE_2: DELETE FROM [SpecialtyPlate].[DBO].[RP_Temp] WHERE [RP_OFF_DATE] BETWEEN DATE_1 AND DATE_2 thanks Aref No. Read them into package variables and then use an expression on the SQLState ...Show All

• tiffeyneohelp How to dynamically set the ServerPassword

  I have an FTP Task where I have to set the server password at run-time. I have the ftp connection manager set up. What I normally do is configure the ftp server connection manager using a dtsConfig file but I can't do that in this case. I won't know the serverpassword until I get a parameter from the user. Thanks Brian.  Yes, I do want to do it in the package because  the package is being launched via dtexec from a generic web app that creates textboxes for the parameters.  I would like to keep the web app  generic and free of package-specific code.  I created a script task and I set the password by getting the ServerPassword property from the ConnectionManager's ...Show All

• Ron Meanor CLR Functions with Optional Parameters

  I'm rewriting a T-SQL function that is called "Proper Case" which takes in a sentence and returns the sentence with the first letter of each word capitalized. The new CLR(C#) function implements new functionality where it can take a string and turn it into a properly cased string, sentence cased string, lower cased, upper cased, and toggle cased. The function takes in one parameter, the string, and the casing type, a string also. I want the casing type to be optional where if it's not passed in it defaults to "proper". The reason why I want this is so that I can easily replace the existing T-SQL function without having to add an extra parameter to each call to make life easier. I know you can do it for SQL sto ...Show All

• k3bdf View 2005 AS cube through the web

  Is there a way to allow users to browse a cube through the web after deployment using AS Something in capability like the AS Cube Browser Or, is Reporting Services the only way to go You should distinguish between the way you browse Analysis Services and ablility to access Analysis Services throgh HTTP protocol ( this is what I think you mean when you say you would like to browse through "the web"). Here is previous thread about client application you have supporting browsing data in Analysis Services http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=674521&SiteID=1 As for the setting up HTTP access. Here is whitepaper: http://www.microsoft.com/technet/prodtechnol/sql/2005/ht ...Show All

• Visumax Parameters via a web service

  Hy, I have to build a report. this report has to be call by a web service. My method to call this report is : oki I found how to give a parameter. So my code looks like that now: [ WebMethod ] public void Amende( string dossierId ) { ReportingService rs = new localhost. ReportingService (); rs.Credentials = System.Net. CredentialCache .DefaultCredentials; byte [] resultStream; // bytearray for result stream string [] streamIdentifiers; // string array for stream idenfiers string optionalParam = null ; // string out param for optional parameters ParameterValue [] optionalParams = null ; // parametervalue array for optional parameters // Preparation de la valeur passee en ...Show All

• Temeraire Announcing a GUI tool for configuring dialog security and routing

  Hi, I am not able to get “Service Broker” under my database Can you tell me what is wrong with my installation Regards, If you are using SQL Server Management Studio Express, it does not have the functionality to view or create Service Broker objects. The paid version of the same lets you view Service Broker objects but not create them. Unfortunately, the only way to create, alter and use Service Broker objects is via T-SQL commands. Please look at the Service Broker section of Books Online, the SQL Server online documentation on MSDN. ...Show All

• bigdogguy numbering in group

  I want to add numbering in group in the reports.(number each row in the detail) when I worked with access it was possible. can I do it in the report services thanks! Ok I find it: =rownumber("MyGropName") thanks ...Show All

• Whoisit SQL Task - passing parameters

  Hello, I have a SQL task wich executes the following statement on a OLEDB connection (SQL 2005 DB): TRUNCATE TABLE DimTime GO DECLARE @CurrentDate AS Datetime DECLARE @EndDate AS Datetime SET @CurrentDate = '10-20-2003'; SET @EndDate = '10-20-2005'; while(@CurrentDate < @EndDate) begin INSERT INTO DimTime SELECT DATEPART(month, @CurrentDate) AS MonthNumberOfYear ,DATEPART(quarter, @CurrentDate) AS CalendarQuarter ,DATEPART(year, @CurrentDate) AS CalendarYear ,dbo.GetSemester(DATEPART(month, @CurrentDate)) as CalendarSemester ,DATEPART(quarter, @CurrentDate) AS FiscalQuarter ,DATEPART(year, @CurrentDate) AS FiscalYear ,dbo.GetSemester(DATEPART(month, @CurrentDate)) AS FiscalSelester set @CurrentDate = dateadd(month, ...Show All

• TimFr&amp;#246;glich Measure should only be calculated for certain Dimension Attributes

  Hi, I've created a Dimension - Organisation (company_name, department_name,room_name). The primary key is Organisation_ID and I have a Measure Room Utilization. I'd like to show this Measure only when Room_Name is selected and with every other member of this Dimension there should occur a 0 for Room Utilization. It works when I create a hierachy inside the Dimension with the following MDX statement: CREATE MEMBER CURRENTCUBE.[MEASURES].Room_Utilization AS case when [Organisation].CurrentMember.Level.Ordinal = 4 then [Measures].Room_Utilization else 0 end VISIBLE = 1; how can I get it going when my Organisation Dimension has the following attributes: company_name, department_name, room_name without hierachy and I onl ...Show All

• R2ks Poor performance querying view from sproc

  We are using SQL SERVER 2005. We have been experiencing horrible performance running select queries from sprocs against views that do outer joins, despite having optimized all of the indexes. Our solution in these cases (and arguably not the best) has been to first select the views into a temp table and then query the temp table for the desired result set. This has greatly improved the speed of which our sprocs run, but we are looking for a better solution. Has anybody else experienced this problem Thanks in advance. Can you please paste your stored procedure code. I suspect it is due to the selectivity of the predicates that means you are getting a poor plan. If you can past the output of sh ...Show All

• Hossam Abdel Wahab Where to put my SQL? This has got to be obvious...

  A noob to SSIS... Have been reading the Wrox book and online help, but can't figure a lot of things out (why don't they ever make books with examples for EXACTLY what you wanna do ! ! ). I have a view on my source DB that transforms it's data into my destination DB's format - mostly for testing currently. I can't assume this view will exist though, when it comes time to do an import, so I am trying to figure out in my SSIS package, where to do this transformation. Should I: Use an Execute SQL Task and keep the SQL in the task itself This seems the most "portable" but I haven't figured out how to actually use the result set (stored in a variable) to do an insert of this data (again, this seems like it should be obvious). Crea ...Show All

• machina SQL Server Configuration Manager to change run as account

  Hi, For the past few days i have been stumped on this problem. Our environment is the following: Windows 2003 R2 64 bit  SQL 2005 SP1 64 bit active/active cluster with several instances. Right now all instances use the same domain account to log on. For security reasons i wanted to assign a domain account for each instance to use. Now the problems start when i am using SQL Server Configuration Manager. I am usually successful in changing an instances SQL server account but once i try and do it for the SQL Server Agent i start to get errors and i am unable to get both running at the same time. Sometimes i will get wmi errors and sometimes the mmc just stops responding. The WMI error i get often is: The server ...Show All

• Nilesh Patel Very High CPU during Full Text population

  I am building my first catalog on my 2005 server. It currently has been running for almost 3 hours now when in 2000 it took a little more than an hour. It seems the bottle neck is my sqlserver. I know that there are 2 other services associated with populating the catalogs but they don't seem to be doing much but the sqlserver.exe is sitting at 98% cpu or more. This obviously is not good. I tried searching for solutions and found nothing that helps. I increases the available memory to the server to 2gb from 1gb but the server is only using 40mb anyways so that did nothing. I am not sure what to do next... The table that is full text has 3 varchar(max) columns plus 10 other varchar fields but I wouldn't think that has anything to do with ...Show All

• rock.aut Multiple sources - single destination

  There are two EXCEL sources one destination table. Each record in the destination should be populated with 2 columns from one source and 2 from other source. Source 1:  ID     Name  1       abc Source 2:  Address   Location  232/2       xyz Destination:  ID   Name     Address    Location  1     abc        232/2        xyz I tried using UNION ALL transformation but it fetches 2 seperate records (assuming that one record in each source). How to achieve this without using SCR ...Show All