Answer Questions

• Krutika Inconsistent performance from queues

  Hi everyone! I have a very brief question... I have 10 queues in my database and each of them are sent equal number of messages... There are instances where they execute/activate the stored procedures very fast but there are times where they don't, does anyone have an idea why this happens Thank you very much for taking the time to read my post. :) I just noticed that I'm only ending the conversation in the TargetQueue and never in the InitiatorQueue (this is associated with the service that initiated the conversation). Could this be a possible cause I noticed that after all the processing, the InitiatorQueue contains a lot of message with message type of http://schemas.microsoft.com/SQL/ServiceBrok ...Show All

• kamkam2 Line feed problem in HTML

  I'm using a string in report which contains chr(10) -> Line feed characters. They show up correctly (there are several lines) in Preview screen and in pdf-format but NOT in browser. I think the browser doesn't understand those characters. Is there a way to replace them somehow with other useful keys If there is an example would be great... I'm sorry but I didn't get it. I have 3 rows long field in report(Fields!Address.value) and that value contains those carriage returns. So should I edit the expression of the field to find where the carriage returns are and replace them somehow try Replace(Fields!Address.Value, chr(10), Environment.NewLine) I use the equivalen ...Show All

• Jinja How to import word documents into SQL Server

  Hi All, I need to import multiple word documents of same structure into SQL Server table. Could anyone suggest the way of doing this Thanks, I mean i want to extract information from word documents into sql server tables. Hemal Shah wrote: I mean i want to extract information from word documents into sql server tables. I'm not sure really. This isn't a common request seeing as Word documents are not structured files. The normal answer to extracting unstructured data using SSIS is that you're going to have to use code. You can download Primary Interop Assemblies for Office that enable you to interact with Word documents using dotnet code - hence you can use them in a script task/component. -Jamie ...Show All

• Jamie Thomson change font weight

  i have one doubt how to change font weight Because i have two records in my table i need to change that particular records only i need to change "BOLD" thanx You can return this information as an additional column as part of your SQL query. Then in design mode, highlight the details row (or individual testboxes) and make the font weight an expression based on the column in you dataset. e.g. SELECT type , font_weight = CASE type WHEN 'special' THEN 'Bold' ELSE 'Normal' END FROM some_table Then the expression will read: =Fields!font_weight.Value You can apply this technique for most properties not just FontWeight. ...Show All

• swapna_n Role of login specified in GRANT UNSAFE...

  For registering UNSAFE assemblies, we have to sign the dll and register it in SQL 2005. Also, the permission needs to be granted to a login.. Example code; CREATE ASYMMETRIC KEY MyKey FROM EXECUTABLE FILE = 'C:\Assemblies\Interop.SQLDMO.dll' CREATE LOGIN MyLogin FROM ASYMMETRIC KEY MyKey GRANT UNSAFE ASSEMBLY To MyLogin What is the purpose of creating this MyLogin and how it serves to access the unsafe assembly. Can anyone throw more light on this. Thanks Baskar In SQL Server it is not possible to grant permissions to a key, only users or groups, so in order to keep the security model simple a way is provided to associate a key with a login. The reason why this is ...Show All

• Michael J. Brown Reporting Services http error 500

  SQL Server 2005 Developer Edition - Reporting Services - Windows XP - SP2 with all updates. The Reports Webpage will not display. I receive an http error 500. I've also gotton http error 403 Website Forbidden. The Reportserver Webpage will display. I've uninstalled IIS and SQL Server numerous times trying to correct the problem. I've also tried registering Microsoft .NET Framework 2.0 numerous times. What am doing wrong or what am I missing ...Show All

• Alex Stankovic How to connect to Analysis Services with Excel 2007 Data Mining Add In?

  I downloaded a trial version of office 2007 and the data mining addin. I do not have an automatic connection to Analysis Services, so most functionality does not work. Is it possible to configure a connection with a trial version If so, does anyone know what the server name is and how to configure it Yes, it was after I installed the trial of analysis services sql 2005. I followed the directions of the link you provided without any success. You can download freely an evaluation version from http://www.microsoft.com/sql/downloads/trial-software.mspx Yes, However, you need either to install SQL Server 2005 (Analysis Services) on the laptop ( or on anothe ma ...Show All

• Liming22102 SQL SERVER Integration service and windows 2003 installation bug

  Hello, I am trying to install SQL SERVER2005 on windows 2003 server.It is not installing SSIS designer.why is it so Regards Kuldeep The designer is installed if you select Client Tools installation. After installation, see the Business Intelligence Development Studio shortcut under Start Menu > SQL Server. ...Show All

• mr4100 SSIS Hung or Exited after a long foreach loop

  I am having some problem in running SSIS scheduled job. The job is processing (updating and inserting) batches of data using Execute SQL Task inside Foreach loop container. But to make sure the batch complete successfully I put the "Begin Tran" Execute SQL Task and "Commit Tran" Execute SQL Task before and after the foreach loop My workflow is like the following.... - Execute SQL Task "Begin Tran" - ForEach Loop Container for a batch of records. - Insert the records into the database - End ForEach Loop -Execute SQL Task "Commit Tran" if the above ForEach Loop complete successfully -Execute SQL Task "Rollback Tran" if the ForEach Loop failed Normally the insert records are around 10~200 ...Show All

• Ray Dyce Long time SSIS package loading

  I load SSIS package using following code: Application app = new Application (); Package pac = app.LoadFromSqlServer( packageName , serverName , null , null , null ); For simple package containing 2 tasks this code executes about 20 seconds. If I load old version (SQL2K) package from SQL2000 then it takes 5 seconds. Is any way to increase loading speed for SSIS packages Thank you Michael. I carry out additional experiments with realworld package (contains 11 tasks) at another computer. When I start this experiment I have to wait 1.5 minutes to load package every time. Then I examine if SSIS running. I discover SSIS don't running after SP1 was applied (widely known SP1 bug). I installed ...Show All

• DHJr Report Model Design Question...

  The senerio: Table: Voucher Fields: Voucher Id, Dollars, other fields... Table: Payment Fields: Payment Id, Dollars, other fields... Table: VoucherPaymentXRef Fields: Id, Voucher Id, Payment Id The relationship is Voucher many-to-many VoucherPaymentXRef many-to-many Payment. I originally brought these 3 tables into the DSV and setup 3 entities in the model (Voucher, Payment, XRef (hidden except for roles)). It allows me to do reports in Report Builder just on Voucher or just on Payment, but it didn't let me create a report to contain fields from both Voucher and Payment. I'm guessing because of the lack of support for many-to-many relationships. I then went back to the DSV and started from scratch creating 2 named qu ...Show All

• mosslake XQuery returning too many rows

  Hi dudes I'm new to the features of XQuery statements in SQL 2005 so apologies if this is a bit of a retarded question. I have the following bit of code running against a table: select xml . query ( ' <results> { for $c in //check where data($c/@dateAndTime) >= sql:variable("@dFrom") and data($c/@dateAndTime) <= sql:variable("@dTo") order by $c/@dateAndTime[1] return <check id="{data($c/@id)}" dateAndTime="{data($c/@dateAndTime)}" negotiator="{data($c/@negotiator)}" supplier="{data($c/@supplier)}" /> } </results> ' ) as xml FROM CheckResults I expect to get a single row returned containing an xml snippet ...Show All

• ukalyan securing access to report manager

  Hi every one, Is there a way i can control access to report manager with some kind of a User name and password. I was thinking that user and role assignments would provide for this service but i dont seem to get it right, otherwise what i would like to configure is to have my report users enter a User name and passoword before logging on to report manager. I need any form of help. Thanks. Nick, Actually the report manager user and role assignment will force a user to login, when you set up your Datasource on the general tab you can require NT login or a Prompt login. On the properties tab for your report, select the security, and you can add a user or role, if you selected prompt for the datasource login then when t ...Show All

• sourendro count + excludeempty gives errors

  Hi, I try to make a calculated cell in SSAS 2000, in the standard foodmart 2000 example. I try a technique from the following page: http://msdn2.microsoft.com/en-us/library/aa902637(SQL.80).aspx For instance, I want to know how many married people there are in a salarygroup in the cube 'Sales'. I define the following MDX instruction for the calculated member "Married customers": Count(CrossJoin( {[Marital Status].[M]}, Descendants([Customers].CurrentMember, [Customers].[(All)])), excludeempty) I get nothing but errors when browsing the cube. Every cell states #ERR When I do not define 'excludeempty' everything's fine. How come Thanks in advance Thanks mister Pasumansky! It works great. :) I di ...Show All

• Bill Foust How do you hide items in the Report Explorer Web Part?

  Does anyone know if it is possible to hide a report in the report explorer web part in sharepoint. I have a report that can't be run by itself. It can only be run when you click on a detail line from another report. Thanks. The items are only hid while in the list view, not while in the detail view. I had to change the view mode of the web part to list view instead of detail view.  I had to do this along with setting the option to "Hide in List View" using the Report Manager. Thanks for pointing me in the right direction. -Somsong You have to do it from inside the reportmanager. Go to http://<location of report server>/Reports Then click th ...Show All