Answer Questions

• TomJ72 How to Email to Microsoft?

  I find a bug in Reporting Services ,How to Email to Microsoft http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=604575&SiteID=1&mode=1 Ian Roof - MSFT ,Thank you very much! To submit bugs, you can contact Microsoft Connect, at https://connect.microsoft.com/SQLServer . ...Show All

• xishan shigri Report Server internal error

  I configuring RS with Form Authenticate. and when go to reportserver , get next error. i not undastand why ------ An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. ------ List log: <Header& ...Show All

• gripusa Multiple Fuzzy Lookup

  Is it possbile to have multiple fuzzy lookup within a data flow I need to have at least 3 fuzzy lookup in a data flow. Here're the conditions that I try to find match: 1=Zip&City, 2=Zip&State, 3=City&State. I've the first fuzzy lookup working fine. After that, I've a conditional split to get any unmatch, then use another fuzzy lookup for a second condition...at this point, I get the error saying "The package contains two objects with duplicate name of output column _Similarity..." I do not need to get the _Similarity and _Confidence, so is there a way to exclude them from returning in the output Any comments Thanks in advance. Thanks Frank. That's exactly what I was looking for. On the 'Inp ...Show All

• db-C SQL Server 2005 SP2 MDX Changes

  Hi all, Upgrading to SP2 changes the way that MDX behaves, as described in the readme ( http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm#_analysis_services ). Can anyone tell me what best practice is to make a query like the one below work as before: WITH SET [Branches] AS '[Branch].[Branch Name].[All].CHILDREN' MEMBER [Measures].[Letters] AS '([Measures].[Contact Count], [Contact Type].[Type Description].[Letter])' MEMBER [Measures].[Letters All Branches] AS 'Sum({[Branches]}, [Letters])' SELECT {[Letters], [Letters All Branches]} on 0 FROM [Communication] WHERE {[Branch].[Branch Name].[Branch 1], [Branch].[Branch Name].[Branch 2 ...Show All

• SimonS_ Does MS plan a GUI

  Hello all, We are planning to base a product on Microsoft SQL-2005 Notification services. However, one of the required properties from this software is to provide the client administrator a user interface to configure the Instance Configuration File (ICF) and Application Definition File (ADF). Working with XML files will not do for us, once the responsibility is delegated from a developer to an administrator. Before going into the process of writing such an application from scratch, I would like to know if Microsoft has such an enhancement on the SQL-NS roadmap, and if so, when it is scheduled to. Does anyone have any thoughts or knowledge Thanks Ziv G. I don't ha ...Show All

• mariek Problem writing to fixed width text file destination

  I am trying to export data from a query in SQL Server 2005 SSIS to a flat file destination. Everything works fine except the rows returned from my query are written to the flat file in one long string (i.e., without line breaks). I have tried appending a new line character to the rows returned from the query but that only throws an error when the package is executed. My rows returned from the query are 133 characters wide (essentially only one column per row) so I have set the properties accordingly for a fixed width file format with 133 character wide rows. Any suggestions or ideas on how to correct this would be greatly appreciated. Thank you, Michael What viewer are you using when looking at the text file Are you sure y ...Show All

• Nirvana Pine Format_String Currency lost by division

  Hello! I use AS 2005 SP1. If I create a calculated measure "C" with a currency measure ("A") and a non-currency measeasure ("B") like C=A/B and define the format_string for the calculated measure as currency. The result is still a non-currency value. Why Thanks in advance! Ole Jepsen If you explicitly specified FORMAT_STRING='Currency' for the calculated measure C, then it will be formatted as currency. ...Show All

• Praveen P UNIQUE/PRIMARY KEY confusion.

  I wrote this stored procedure and it works fine, it seems. The questions I have are as follows: (1) What is the difference between PRIMARY KEY and UNIQUE. They seem to pertain to the same behavior. When I used only UNIQUE as qualifier I did not see that the column was marked as primary in the SQL Management Studio. What I need is for a column to be unique in the sense that it would not allow duplicate values and it must have an INDEX on it. I need it to be descending . (2) Did I do it right or there are aspects in here I do not quite see set ANSI_NULLS ON set QUOTED_IDENTIFIER OFF GO ALTER PROCEDURE [dbo].[CreateTableDailyClose] @symbol varchar (10) = null AS BEGIN SET NOCOUNT ON; DECLARE @SQL VARCHAR(500) SET @SQL = 'CREATE TABLE dbo. ...Show All

• kevinwebster83 SSAS 2005 - Displaying metric values for some elements of dimension only

  Dear all, I have certain metrics which, when crossed with my Product dimension, must display values for some elements of the dimension only. For the other elements, it must display 0. This rule applies to this dimension only. Can someone help me on how to achieve this Regards, Pedro Martins ...Show All

• zenzai Calling SSIS packages from ASP.NET - Packages with file system tasks end abruptly

  I've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem. Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs ...Show All

• Soteriologist Trigger- dump 'inserted' table to temp table

  I want to pass the 'inserted' table from a trigger into an SP, I think I need to do this by dumping inserted table into a temporary table and passing the temp table. However, I need to do this for many tables, and don't want to list all the column names for each table/trigger (maintenance nightmare). Can I dump the 'inserted' table to a temp table WITHOUT specifying the column names It is hard to implement this type of auditing code. Unfortunately, the inserted/deleted virtual tables can only be accessed within the trigger code and only within the body of the trigger as static statements. So this means these tables are not visible even in dynamic SQL code executed from trigger body or SPs that are ...Show All

• TexasDeveloper Is this a real IN/OUT parameter?

  I have the following stored procedure definition: CREATE PROCEDURE insertWsdls @url varchar(128), @source varchar(64), @hashcode int, @wid Integer output AS INSERT INTO Wsdls (url, source, hashcode, scan_date) VALUES (@url, @source,@hashcode, getDate()) set @wid = @@IDENTITY return GO When I looked at SQL Server Manager Studio, I found parameter @wid was identified as Input/Output parameter. However, it is defined as output in the procedure creation command. Why does the parameter @wid become an Input/Output parameter Every parameter of a stored procedure can receive input data. Output in sqlserver simply means returning the current value back to the calle ...Show All

• Max Andrade query result in a variable

  Hello Again, did you miss me ok now i have this problem. I need to make a query that return one single data. I need to store this data in a variable. Something like that: DECLARE @A VARCHAR(50) @A=SELECT mycolumn FROM mytable WHERE mycolumn = 'Something' There is a form to do it Thanks Friends You were very close. All you need to do is switch the variable placement like such: SELECT @A = mycolumn FROM mytable WHERE mycolumn = 'Something'. Just make sure your filtering condition returns a single value or you can get differing values assigned to the variable. Happy querying... ...Show All

• Han Qiao sync to Oracle

  Our backend database is Oracle 9i, and now I need to write an application for PDA, which is SQL Server Compact Edition powered. Here is my question: Is there any way I can sync data between PDA and backend database Can Sql server compact edition do this Any resource Thanks in advacne. There are two options other than some technology that Microsoft is still working on (a new synch framework) and not due for a while. The most common approach is to put some web services together that can get and put data - ADO.NET 2.0 code in the web methods can access Oracle. A typical design for this involves some web methods that GetTable(name), GetTables(), etc and use a drop and replace on the device database (much like RDA). The most importan ...Show All

• jturpin Need to copy All oracle tables to SQL Server 2005

  I am racking my brain on this one. I am migrating Oracle data to SQL Server and would like an SSIS package that will copy the oracle data from every table to SQL server. I already have the schema set up in SQL and a straight copy of a specified table works fine between the OLEDB source and OLEDB destination. However, when I set up a loop which sets a global variable for the table names, which are identical on both dbs, and try to set the OLEDB Source and Destination OpenRowsetVariable to the global variable, the process fails with these errors with all validation turned off: [OLE DB Source [18]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code ...Show All