Answer Questions

• christophe.lws ssrs 2000 - Render() hangs, rrRenderingError

  Just inherited a windows service that .Render()'s reports using SSRS 2000. Apparently the thread is blocked on a .Render() call and SSRS was unable to render the report (rrRenderingError). No error/exception, just rrRenderingError in the SSRS db. note: of 2000 report instances this is happening maybe a dozen times. still gathe Assumming there is an error not bubbling up... I considered doing a .BeginRender(), with the hope of checking to see if the report had errored out. How does one correlate a *Render() request with completed reports or with the JobList I don't see how to get/provide a collelation token :-|  Background: indications are that the thread is alive, working on proving this the service plays "man in the ...Show All

• cplusplus1 Drillthrough is incomplete

  I have a strange problem in my cube when drilling down to details. If I run the following query and leave out the DRILLTHROUGH, I get only one number as result, 7. The Measure Counter is defined as "COUNT on lines" of the source table. So I expect that the number 7 results from 7 lines in the source table - And when I run an SQL query translated to use the same filter options as WHERE part, I do indeed get 7 lines matching the date and other settings I asked for. Everything ok so far. When I execute the MDX query with DRILLTHROUGH I get only 3 lines as result - I remove the DRILLTHROUGH again and get 7 as result again... what can be the reason for this DRILLTHROUGH SELECT {[Measures].[Counter]} ON 0 FROM ...Show All

• ElliotHC Access with an SQL Server backend.

  My question is this: "Does anyone know where to set up the connectivity for an access database to store data on an Sql Server " Hey Lamot, Sure thing. Go into access and choose the tables tab. Right click a white space and choose "Link Tables" in the "Files of type" drop down, choose ODBC databases. You may have to create a new DSN which is no problem, choose "New" choose "SQL Server" (normally at the bottom) next, give it a name, next, finish, choose your server, next, choose your authentication method, next, choose database for this connection, next test it if you want (the connection) finally choose finish. You are now presented with a list of tables on the sql server for the co ...Show All

• Sweed Stripping out numbers from a string

  Hi I have a field that starts with numbers and then has a description after if, eg. "123 This is the description for string 123" 1. How would I go about stripping out the first instance of number to leave the string as "This is the description for string 123" thanks. Bill Bill: Maybe something like select replace ('123 This is the description for string 123', '123', '') or select ltrim(rtrim (replace ('123 This is the description for string 123', '123', ''))) Dave Thanks both, sorted. Bill Bill: Try replacing the literal with a variable -- something like: declare @sep var ...Show All

• fishy_swa The best Data Transformation tool to Update/Insert

  Hello, I have some data coming up from an SQL Server source, I have to add it to another SQL Table on the basis of what destination table already have. For instance, if there is already an entry there for particular record (based on matching primary key value), then I just need to updated 3 columns, otherwise need to insert. The problem is, I know how to do it by using script component, but I am wondering if there is a better tool that saves me writing code Any idea Thanks, Fahad slicktop wrote: so if we are talking about a large target table then this method seems like it would be much slower than the alternative. If you have 500K rows in the target and you have to cache all these rows into memory, I can't see how that wo ...Show All

• Markward Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host.

  Hi, I'm having a problem processing my cube. I keep getting the error stated below everytime I process the cube. I'm a newbiew and can't quite understand the error fully. I'm processing the cube from the server itself so I cant understand why there will be a communication link error.Why do I keep getting this error OLE DB error: OLE DB or ODBC error: Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Protocol error in TDS stream; HY000; Communication link failure; 08S01; TCP Provider: An existing connection was forcibly closed by the remote host. ; 08S01. Errors in the OLAP storage engine: An error occurred while the 'Tbl Error Code' attribute of the 'Tbl Error Code' dimension from the 'CRM_AP' database was being pr ...Show All

• Rabtok Sending an HTML Mail Message with the Script Task DOESNT WORK 4 ME

  I set up the "Send Email Task" succesfully with "SMTP Connection to myExchangeSERVER" using "Windows Authentication" However, as we all know - you can't have html format for the Send Mail Task. BUT this piece of code straight from MSDN doesnt work for me - each time it pops up this "Mail Sent Succesfully" - but I receive NO freaking EMAILs !!! Am I missing something or is it another one of those Microsoft "gotchas" Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports System.Net.Mail Public Class ScriptMain Public Sub Main() Dim htmlMessageTo As String = "me.here@mydomain.com" Dim htmlMessageFrom As String = "SSIS@m ...Show All

• Nick Darnell Table visibility

  Hi, I have a table in my Sql report which dynamically displays data .If there is no data in the dataset i don't want that particular table to be shown.How do we do that / Hi, Thanks Suess , it definitely worked....but the table border remains as it is...i have given border style as solid. I i remove the border style then that table is not displayed(as wanted..) thanks There is a "No Rows" property in the table which can be used to display some information instead of the table, you can also use Something like " " in there. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- What about ...Show All

• alzikan The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro) after SP1

  Having installed SP1, my SSIS packages using the OLE-DB Provider for Visual Foxpro no longer work. Using the latest version obtained from here: http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en When attempting to create one SSIS from scratch, the message thrown is: "The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro)." The radio button option of "Copy data from one or more tables or views" and then selecting the "Next >" throw the error. It has to be the SP1 causing the problem because nothing else changed on the Server and everything was working fine prior to this. Microsoft, any feedback on this ...Show All

• Kaiser28 Problem With Quotes in @[System::ErrorDescription] Variable

  I am using an Execute T-SQL Task as a part of an OnError event Handler in my SSIS Package. When occurs an error, using the Expressions-feature, my Execute T-SQL task builds an Insert Statement to insert the @System::ErrorDescription into a table. " INSERT INTO [ErrorDB].[dbo].[ISErrors] ([EventType] ,[PackageName] ,[TaskName] ,[DateDone] ,[Status] ,[Host] ,[ErrorCode] ,[ErrorDescription] ,[Comments]) VALUES ( 'OnError' , '"+ @[System::PackageName] + "' , '"+ @[System::SourceName] + "' ,getdate() ,'Failed' ,'" + @[System::MachineName] + "' , null , '" + @[System::ErrorDescription] + "' ,null ) &quo ...Show All

• Andrey33 Multiple result sets from a stored procedure

  I have a stored procedure like the following. This returns 2 result sets, however i only want it to return 2nd (SELECT SomeField FROM SomeTable). How is this done Note - it is not possible to change 'SomeSPThatReturnsAnIntAndAResultSet ' CREATE PROCEDURE [dbo] . [SomeSP] @SomeParam int AS BEGIN SET NOCOUNT ON ; declare @SomeScalar int exec @SomeScalar = SomeSPThatReturnsAnIntAndAResultSet @SomeParam if @SomeScalar = 0 BEGIN SELECT SomeField FROM SomeTable END END Hi, If you just fill in data with your stored procedure, there should be no result passed back. Could you post your inner and outer complete procedure to see what you wan ...Show All

• Michael G. Emmons Is it possible to version custom SSIS components?

  Is it possible to use versioning at all with SSIS components My experience so far is that I have not figured out how version them at all, because if I change the version number, then apparently the <property name="UserComponentTypeName" ...> has to be changed in every single reference to the component, in every dataflow, in every single dtsx file that uses the component at all -- this will be a tremendous headache as some of this stuff is in source control. It seemsl clearly infeasible to check out and substitute and change all these references, and check them all back in, except very infrequently -- surely not feasible to do it for each small change. I am in the habit of versioning dlls and assemblies, and actually chang ...Show All

• Imanol Stored Procedures

  Hello Have you ever worked with stored procedures I am making an application in .NET using CSLA framework and I use as a data base one i've made in Access (not my wish) and I can't really manage those stored procedures. Any help Thank you, Monika You should be more specific. Hello, What I wanted to ask is how you use them, for example, in this code : /****** Object: StoredProcedure [dbo].[addAssignment] Script Date: 01/18/2006 09:28:48 ******/ IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N '[dbo].[addAssignment]' ) AND type in (N 'P' , N 'PC' )) DROP PROCEDURE [dbo].[addAssignment] GO what sys.objects represents and what are those "N" and "P&q ...Show All

• that_guy problem with setup XMLA

  i am using XMLA on windows Server 2003 (sp1) and SQL server 2000 (SP4), and i am not able to connect to XMLA source http://my_serwer_name/xmla/msxisapi.dll when i try to connect http://my_serwer_name/xmla/msxisapi.dll in browser, i don't get soap error. browser connecting unlimited time. I try with anonymus and integred authentication. Always the same result. Any ideas ...Show All

• Listing HELP: REPORTING SERVICES Pie Chart Point Label Formatting

  I'm trying to complete a report with a few pie charts. these charts need to show the category, the associated revenue, and the % of total. I can get the first two but am having a problem with trying to add the % to the label. This is the only show-stopper for my report. thanks Thanks Robert Its work for me too Robert, thanks for the input. will use immediately. You can calculate the percentage by using an expression for the data point label. E.g. =Sum(Fields!Sales.Value) / Sum(Fields!Sales.Value, "ChartName") See attached sample report. -- Robert ================================== < xml version="1.0" encoding="utf-8" > <Report ...Show All