Answer Questions

• Angal multiple datatables passed to one report?

  Is it possible to pass multiple datatables to one report (within one dataset) My stored procedure would have two or more select statements. Only one resultset is supported. You could add a parameter to the stored procedure (or write a wrapper). The parameter determines which resultset is returned. You would then define multiple datasets in the RS report and call the stored procedure with different parameter values. -- Ro ...Show All

• Stubabe D Problems creating a stored procedure in Management Studio

  Hi, I am probably going to sound really stupid but I have recently installed SQL Server Management Studio and been trying to figure out how to create a stored procedure in it.   I have created a database called 'BTL_Dictionary' and that works fine. In the Object Explorer window when I click on the database, I get the tree view of all the different options. In order to write the stored procedure , I clicked on Programmability --> St ...Show All

• egyptian_bean Compilation/sec is more on production where recompilation / sec is zero

  Hi Team, Our production Environment is SQL server 2000 with SP3. I noticed lot of compilation/sec (where recompilation/sec is closed to ZERO). I know every stored procedure will get compiled initially then it may get recompiled for lot many reasons & I have very good understanding of reasons for recompilation & lot of document on that. Where as I am trying to understand what causes for compilation. I noticed we are not using ...Show All

• Ulrich Vogl Access DB2 on AS/400 using IBM OLE DB Provider

  Hi, I am using the IBM OLE DB Provider (IBMDASQL) provided with Client Access (IBM) to access a DB2 database on an AS/400 (iSeries). Using an OLE DB Source in the data flow and Access Mode set to "OpenRowset" this works fine (even though I think it is quite slow). However, when I change the Access Mode to "SQL Command" my data flow fails at the OLE DB Source component - not giving me any meaningful error description (only the mysterious "... th ...Show All

• marcel123 Error when trying to use checkpoint file

  I have a package with settings SaveCheckpoints=True and CheckpointUsage = Never.  After the package failed I fixed the cause of failure by setting a database column to allow nulls.  Then I went to our web app that we built to monitor package execution and clicked on the button to restart the package.  The web app loads the package and then sets the CheckpointUsage property of the package object to 'Always'.  Then it ...Show All

• Craigeth display time for tooltips on reports built in Reportserver

  Hi All, Users Love the tooltips. But the tooltip disappers in very very short time, before they get to read it. Can any one helpme in cotrolling the lenght of the time, tooltip is displayed. Regards Bobba I closest I could get is ask users to go to controlpannel>display>appearance>advanced>item>tooltip. But it only lets me change the font. If any one found a way to control ...Show All

• valimar Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• David Weller - MSFT How can I put a newline within a string column?

  I am using Derived Column Transformation Editor. I have 3 string values which I would like to combine them into one string and have a newline character inbetween the 3 strings. I cannot see a Char() function similar to TSQL to use for this purpose. I thought about creating a Variable but even to that I don't know how I can assign a newline character. Any ideas Not required today, but for info, you can make ...Show All

• Sathish Alagirisamy Empty cube after date dimension added

  In 2000, we could tell immediately whether there was data in the cube by running the SQL Statement that was used to process it. We could also troubleshoot join issues between dimension tables. In 2005 the process has changed. The cube update appears to be independent of the dimension update. When I add a custom date dimension to my cube, all data within the cube disappears. My measures are empty, and I cannot get data back no matter what I sl ...Show All

• Graham D Can I Turn off Auto Execution of Report when all parameters have default values?

  My situation.... I deploy a report in Report Server.  Ther report has 5-10 parameters.  When I design the report, I supply a default value for each parameter,  similiar to the "Add a select all option" tutorials. So I end up with defaults like "Select a Project Manager", "Select a Fiscal Year", etc...  I use dynamic queries to read the parameters and insert the appropriate logic into the where string of my main dataset. ...Show All

• david.tooley Adapters in SSIS?

  Are there adapters available to connect to SSIS for 1. Siebel 2. IBM MQ Please let me know what are the alternatives if they don't exist. I am still struggling to understand the core functionality difference between BizTalk and SSIS Thank you. Not out of the box but I believe a company called Attunity build adapters for other systems so you might find them useful. Core difference between SSIS ...Show All

• Madhukar_KR Localize Web ReportViewer control in VS2005 / SSRS 2005 / ASP.net 2.0???

  Is it possible to translate the web report viewer control to another language (german, french...) I need to integrate the control in a multilingula website. I need also to change the messages from the report during the rendering "Report is being created". And is it possible to change the little green animated icon during the process of creating a report Thanks, Dirk Hi Robert, I followed the steps bel ...Show All

• Jurassic Problem with nested try catch blocks in SQL 2005

  hi All, Code: begin try begin transaction trans1 //some transaction begin try begin transaction trans2 //some transaction //Raise Error //commit transaction trans2 end try begin catch //Raise error end catch //some transaction //commit transaction trans1 end try begin catch //Rollback trans1 end catch] ...Show All

• Geeta matrix issues

  example rpt..               |      Last year                   |          this year               | Resolution | Resolved | Closed | Cost&n ...Show All

• XavierMe HTMl not refreshed after deleting group from table

  After I designed a simple table with a few fields (student Name, test score) and then I added a 'school name' group as a grouping level. The table displayed fine. However, I then deleted the 'school name' group from the table but it continued to impact the data display (no data shows, just the heirarchy restructuring). I have gone through all cells, rows, etc to ensure there is no remaining reference to the 'school name' group. When I looked at ...Show All