Answer Questions

• MessiahAndrw Calling SSRS web services from Java using Axis

  Hi, I'm working on a project where I'll need to call the SSRS web services from a java servlet. We are using the Axis implementation of the SOAP protocol. I've previously used SSRS web services from C#, but not from Java. Before I start this endeavor does anyone have any bits of wisdom they'd like to share that's going to make this easier Also, I've searched for tutorials, samples, source code, etc.. for this situation (that is, using java to call SSRS web services), but can't find anything available. Does anyone know where I can find resources such as these for this particular technology pairing Thanks for the help. -M Try WSDL2Java tool to create a java proxy to the reporting services. The WSDL is accessible from one o ...Show All

• rod_r Report Manager not responding

  Hi, I'm hoping to get some help here. I've spend countless hours trying to get Reporting Services running without success. When I run the Report Manager it does not respond. Coming up with Opening page http://localhost/reports/Pages/Folder.aspx . . . The progress bar ticks along but the page never actually loads. The Configuration tool shows green icons everywhere. No errors in the Event viewer. I am running Windows XP Professional with SP2. I have uninstalled and re-installed IIS, ASP.NET and SQL2005 numerous times. Varying the order, all without success. What else is involved I have loaded Service Pack 1 and the latest hotfixes. What else can I try Thanks in advance, Claude It looks li ...Show All

• Chimme Process exit code:1073741819

     I have changed a SSIS package last week. Now, I met the problem that the package sometimes failed both in SQL agent and the BIDs.   SQL agent  just give the detail: Process Exit Code -1073741819. The step failed.    In BIDs,when I Check the log,there is even no error. But the last Infomation in the output windows is the package canceled. It just like somebody stop running package manually.    The more strange thing is the package sometimes succeed with running the same data.        Thanks for your help   I work with David, so I thought I'd post an update. The support guys took a look at the dump, and ...Show All

• AlexBB SSIS Transfer Database task not transferring keys

  I set up a basic Transfer Database task (online, copy) to copy a DB. It works great except for the fact that it isn't transferring the PK's and FK's. It also looks like it did not transfer the views. Any idea why Anything else the Transfer Database task doesn't actually transfer It looks like the "Transfer Database" task only does tables. However, the "Transfer SQL Server Objects" allows you to select everything like you need. Anyone have a clue ...Show All

• Zingam Feedback on Microsoft Connect Site

  I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage Almost everyone  (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.   Links to a couple new submissions that look interesting:   1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks 2. ForEach SMO Enumerator Filtering   I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high ...Show All

• Jonathan Cran DTS "The Parameter Is Incorrect" Error

  I'm running SqlServer 2000 and am trying to write a DTS. For some reason I keep getting that error for my Dynamic Property Task and not sure why. I've tried giving my Package a password like was mentioned in another thread on here, but that didn't work either. I'm trying to dynamically set a Data Source for an Excel connected, using a query. Query: DECLARE @directory VARCHAR(1000) SET @directory = 'C:\' EXEC [Legacy].[dbo].[spr_GetNewestExcel] @directory The Store Procedure: CREATE PROCEDURE spr_GetNewestExcel ( @directory VARCHAR(1000) ) AS BEGIN DECLARE @cmdParam VARCHAR(8000) --Temp Table that saves the output of a DOS command. CREATE TABLE #output ( output VARCHAR(300) ) --Temp Table that saves the output ...Show All

• Gunston connection to AS cube error

  Hey all, wondering if any of you can help me.. I have built an AS cube and deployed it. I am now trying to set up a model in report manager so that i can build reports off the cube.. I have setup the datasource as follows : Name: GAPLSales_DS Connection Type: MS SQL AS Connection String: Data Source=MANT4003;initial catalog= GAPLSALES GAPLSALES is the name of the database on AS Intergrated Security.. I then try to create a model, and i get the following error: Cannot create a connection to data source '' . (rsErrorOpeningConnection) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote erro ...Show All

• Masi SQLexpress Certificates

  Hello: I have access to a microsoft certificate server and I have generated a server certificate for use in my SQLexpress installation. The certificate was installed into the personal folder of the local machine. The MMC certificate snap in can see it fine. When I use the SQL server configuration manager and look in the certificate tab and try to use the drop down to find the certificate so SQL express can use it, nothing shows up. Can someone please give instructions on how I can get SQl express to use the server certificate that I just installed Thanks. Larry Please check this blog and see if your certificate is valid. http://blogs.msdn.com/sql_protocols/archive/2005/12/30/508311.as ...Show All

• scribework Chart in Report Builder

  hi there I am just designing a simple chart in Report Builder - but when trying to drag any field into the value field of the chart (it doesn't change colour and won't accept any field). If I drag a field into the category or series the curser changes and on approaching the chart properties they seem to change colour. Can someone help to what can be wrong thanks Dianne thank you Carolyn that did the trick. just to clarify - this is a temporary arrangement no way to save the aggregate field cheers for your help Dianne cool - so I am using BI to edit my model project = yes add new source field = yes how do I make it an aggregate field tha ...Show All

• LpAngelRob Error :(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

  Hi, I am trying to connect to my SQL Server 2005 but it gave me following error message. TITLE: Connect to Server ------------------------------ ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) So, Please help me to solve this problem. tnks. it means u don't have any local instance installed on your machine. If you really need a local instance , again go tho ...Show All

• Steve Kibble Data-Driven Subscriptions

  Hi I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine. Any help, comments, or even suggestions will be very welcome. Kind Regards Carel Greaves There are two log files there so i pasted both for you <Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product> <Locale>en-US</Locale> <TimeZone>South Africa Standard Time</TimeZone> <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__11_22_2006_00_04_51.log</Path> <SystemName>FORGE2005</SystemName> <OSName>Microsoft Wind ...Show All

• Part Time Australian Integration Services Designer (Visual Studio) very very slow

  Hi all I have some performance issues when developing Integration Service Package ... It is very very slow for example when I try to add new connection in Connection Manages, it takes about 2 minutes just to open the property window. On another pc in the same environment it works ok. In the past I have doing a lot of SSIS Packages ... Is there any cache to empty Thanks for any comments Best regards Frank Uray 1.For integration service designer You should also install SQL 2005 SP1 and the SQL2005 hotfix 2153. 2.another tip I found in the newsgroups was : In internet explorer go to Tools-> options-> advanced Uncheck the tickbox &quo ...Show All

• kennm Developer Edition vs Enterprise Edition

  Does anyone know why the same cube deployed on 2 different servers (one Enterprise Edition, the other a Developer Edtion) with the same MDX query would return 2 different Results MDX query I am using: WITH MEMBER [Measures].[TimeChargedToDate] AS 'SUM({NULL:[Timesheet].[Date].&[2006].&[9].&[15]},[Time Charged])' SELECT NON EMPTY { [Measures].[Time Charged], [Measures].[TimeChargedToDate] } ON COLUMNS , NON EMPTY { ( [Project].[Project Number].&[Z07600] * [Staff Member].[Staff Member Name].[Staff Member Name]. ALLMEMBERS ) } ON ROWS FROM ( SELECT {[Timesheet].[Date].[Year].&[2006].&[9].&[2] : [Timesheet].[Date].[Year].&[2006].&[9].&[15]} ...Show All

• barkingdog How many user current "connect" to a row in table.

  Hi all... Iam a newbie and i have one question want to ask experts ... . I am current working on one App which have some user connect to database at the same time. And i want to know: how many user connect or use (read , update) to one row in a table Could it be possible to know that If you have one solution to solve this problem , please let me know :) ... Could it be done by Software , T-SQL or anything ...., iam happy to know. Thanks all. Iam using SQL server 2000 and don't have intended to update to sql server 2005, so i can't use RLV. I ask this question because i want to notify my clients when data was changed by users. Is there any idea for me to solve this problem if have , please show me more details Thanks .:) ...Show All

• Ronald L Switching Excel Worksheets Based On Date

  Hello, I need to pull data from an Excel Workbook (DTS Excel Source) where the data is stored in worksheets that are each named one of the twelve months of the year. The package is fired by a job that runs once a month. Currently, I have to go into the select statement of the Excel source before the process runs and change the name of the Worksheet that the data is pulled from. How can I set up the sql statement for the Excel source so that I can pull from the Worksheet that contains the name of the current month Thank you for your help! CSDunn Thanks for that input. I was also thinking about setting up the Workbook as a linked server, and doing something that way. What might be possible if I ...Show All