Answer Questions

• CrazyAboutWPF sql expree instalation error

  Hello my big problem for today. I downloaded sql express advanced with reporting services and when I try to install it on step: "sql server database services" I recive the error below: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa' ...Show All

• udooz Drill down matrix report slow performance

  I have created OLAP cubes and we are creating reports on top of them. The reports take incredibly long to render (40 seconds to 5 minutes). The MDX for the reports runs in less than 15 seconds when executed as a query in Mgt. Studio. Browsing is also fast. The reports are drill down matrix-type reports and they do eventually display properly. Not that this should help with the mechanics of the issue but the report data source query will show ...Show All

• popsdawg SP1 Installation Failure for Reporting Services Instances

  The upgrade was alright for my first/default instance of reporting services but failed for the other 3 non-default instances. I was running SP1 using remote desktop connection. I got the following error at the report manager and the reporting services configuration's initialization. Is there any way to get around this The version of the report server database is either in a format that is not valid, or ...Show All

• Denton Using SSIS Package as Source for Reporting Services

  Hi I have created an SSIS Package which provides Data to a DataReaderDestination. Next I have uncommented SSIS support in rsreportserver.config and rsreportdesigner.config After that I have set up a shared Datasource in ReportServer and created a Report using that DS of type SSIS. /FILE D:\ETL\ReportingDataService.dtsx When trying to see the report using http://localhost/reports I get a message that tells me that the package fails to ...Show All

• Blerus How to consume a Datareader destination in code?

  Hello, I can gain access to and execute my package using the Application and Package objects. I am handling the events of the Package object and can even see the OnPipelineRowsSent event when it fires to deliver the rows to the Datareader destination. How do I gain access to those rows for use in my application I have scanned the SSIS object model looking for the right place to hook in, but was not able to find one. Am I heading in the right dir ...Show All

• Janaka Debugging pure T-SQ stored procedures

  I understand that there has been some dscussion on the subject of debugging T-SQL stored procedures.  Can you point me to this information   I am not interested in how to debug CLR stored procedures as that is well documented. Thanks Bill Zack I'm working with beta2 and sql05 (april ctp) on the same box.  Until recently I had the 'step into' selection.  After formatting and reinstalling, the option is missing.&nb ...Show All

• gary_gill Where is the package running?

  When I ran a package directly on the machine with sql 2005 installed it ran at a fine speed. But when I used Remote Desktop to access the same client and run the same package it was much slower. 1. I think that the package is running in the memory\cpu of the local machine. Is this correct 2. Is there any way for the remote client to run the package in the server's memory\cpu TIA, barkingdog ...Show All

• david sette Open Report Builder and Link to Report Directly?

  Hi, I've created a simple webpart that lists all the reports that a user has created using the Report Builder and next to each line item is an "Edit" link. What I would like to do is open up the Report Builder application and pass a parameter of the report path or something like that so that report builder opens up the report automatically. Is this possible Thanks Tristian THanks, this ...Show All

• kad Possible to use a Sharepoint List as a Datasource?

  In Reporting Services 2005, is it possible to create a data connection to a sharepoint list If so, what connection type and connection string do i use for this Hi, In case you are interested we are selling a reporting services (both 2000 and 2005 version) data extension for sharepoint. This extension makes it possible to build report using sharepoint lists (including libraries). Several lists may be joined using SQL-like operat ...Show All

• Jaque DataBase Connection

  hi everybody; my questions about when database connection : i am when connecting database latter receiveing exception error.Error is : An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll codes : SqlCeConnection cnn=new SqlCeConnection("Datasource=\\My Documents\\Business\\LOREAL.sdf"); cnn.Open(); // Exception is here help me.. ca ...Show All

• state_dba how to use sqliostress.exe on remote server?

  Hi, Can anybody help me with the command to use sqliostress.exe on a remote machine. I have, SQLIOStress /Fc:\temp\Stress.mdf /Lc:\temp\Stress.ldf /N /S3072 /I32 but how do I mention the remote server to test this utility. Regards, zia I don't think this is an option. Why can't you run it on the server locally I am trying to calculate the IO operatio ...Show All

• Bill Tang at ut How Do I Start New SQL Server 2005 Database?

  I just installed SQl Server 2005 on my Windows XP Pro system. But I can't figure out how to start the Database Engine. In the MS SQL Server Management Studio I see one Database Engine, but not SQL Servers. If I do "Update Local Server Registration" nothing happens. If I do right-click "New Server Registration" I get a databse icon with a white open circle. If I the try "right-click, Connect, Object Explorer" I get & ...Show All

• SteveJ Package execution with dtexec and in vs debug differs!

  Hello I have a package that contains a Foreach loop container. Inside teh loop a data flow task uses the loop variable as a parameter for 2 OLE DB sources (same SQL 2005 db, very similar complementary queries see below). When executed in debug mode in VS the quereis always return some rows (as they should) for each value ofthe loop parameter. I have stepped through each iteration with and withou breakpoints and all the queries returned som ...Show All

• Basic Veteran Using Data Source view in Import export package within same solution is not possible ?

  hello ,   I want to download data from an AS/400 to a SQL 2005 Database. Within Sql server 2000 it was possible to do more than 1 transformation with just 1 source connenction and 1 destination. In SSIS I have created: -  new solution -  data source -  Data source viewer ( I made named queries to format the data as i want it to be in Sql) Although it is possible to view the named query data it does not ...Show All

• rajabharathi Knowing what is grouped?!

  Hello! I have a table "A" like this shown bellow and a problem... Vr Kon Value ID DZ PRM 22900 -16.00 101 M PRM 22900 16.00 102 P PRM 22900 -728.19 103 M PRM 22900 728.19 104 P I am doing simle grouping on this table... Grouping is by Vr,Kon,Dz and Value is summed. Select is like this SELECT  Vr,Kon, sum (value) from TableA GROUP BY vr,kon,dz So, my results look like this: ...Show All