Answer Questions

• Ayyappan Sethuramalingam decimal separator

  Hi Im experimenting with the reportViewer control in a .net 2.0 winform application, and I'm having a little problem: I can find no way to change the decimal separator(or the thousand separator) of a column of numbers in a table. I have tried all sorts of Format(), formatNumber() and FormatCurrency(). I've also tried to explicitly set the CurrentCulture of the application to a new cultureinfo object, and I've tried to change the culture of th ...Show All

• Przemysław Rokicki SSIS COLOur Settings

  How Can I change colour setting in SSIS I want change the colour of  link arrow Data Flow tab.For Example flat file source to OLe DB destination.I am a  colour -bilind and I confuse which of them green or  red. Thanks.   Sadun_Ozcelep wrote: How Can I change colour setting in SSIS I want change the colour of  link arrow Data Flow tab.For Example flat file ...Show All

• Matt# multiple-step ole db error

  When trying to connect to sqlexpress, I get the rather uninformative error message: Error No. -2147217887 Multiple-step OLE DB operation generated errors. Check each OLD DB status value, if available. No work was done. Here's the connection string I'm using: strDbConn = "Data Source=.\SQLEXPRESS;AttachDbFilename=" & _ DbPath & ";Database=rawtf_1;Integrated Security=True;User Instance=True; " & _ " ...Show All

• Pebble_Stud ADOMD.NET 8.0 dependencies for connecting to both AS 2000 and AS 2005

  I've got a C# application developed with Visual Studio .Net 2003 which uses Adomd.net (8.0) to access cubes on SQL Server 2000 Analysis Services as well as SQL Server 2005 Analysis Services. In the MSDN reference page I noticed that I can set the connection parameter "ConnectTo=Default", and now, after installing the SQL Server 2005 Client Connectivity components, I can make connections to both AS2K and AS2K5 from my development machin ...Show All

• Ira Hining using ssis to generate load

  hi. i'm trying to use ssis for something it wasn't meant for (i think)...  which is load generation. I have a table which has exec sql statements. I want to load this table, multicast the statements into x recordsets, then get x sql connections and execute these statements. so far i can load the table, and multicast it into x recordsets. But i can't figure out how to execute these statements by getting them out of the dataflow and ...Show All

• Marcus Ogden SSIS delta

  Hi , i'm new to this platform and am wondering if there is an easy way to identify ADDs changes and deletes between two tables - or whether i will have to do a ror for row comparison using the business key Any suggestions would be greatly appreciated.. thank you George Bassili George, This may be of help to you: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• Bob McD IO Stats and Execution Plans (text)

  Hello, As a requirement, I have to send the DBA's IO Stats and Execution Plans (in text format) to them; with 2005, is there a more automated way Before, I tried using a script generator, but it really never did the trick. Is there a better way of automating Thanks. With SQL 2005, you can get this information in XML format in management studio, via a SQL Trace, or from DMV's on the server. DMV's though ...Show All

• Gene W IIS Internet Info Services

  Hi, I'm trying to install SQL Server 2005 Enterprise edition. It is telling me that I don't have IIS installed and that it may cause some problems. I can't find where to install from add/remove components nor can I find it in any of my network connections. Does anyone know where to install this from Thanks in advance. Newbie.......Eric Yeah that's a bummer. Well I'm just learni ...Show All

• shz ReportViewer Port

  Hi I have a web application that leverages ReportViewer to pull reports from a reporting server.  This works fine until I move the application to a web server that sits on our DMZ.   Does anyone know what ports I require opened   i.e 80, 8080 or some other ports Also is it possible to configure the port used. I appreciate all comments. Thanks for your help Stupid question fro ...Show All

• Thomas Logan - MSFT An error has occurred during report processing. (rsProcessingAborted) The report server installation is not initialized. (rsRep

  I'v reinstalled RS, then I configuret it. But when I want to open a report raise this error An error has occurred during report processing. (rsProcessingAborted) The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Any Ideas Thanks in advance It happens because another instace of RS was running. See it at: http://msdn.microsoft.com/library/default.asp url=/library ...Show All

• Daniel Bertinshaw Problem selecting Group header should remain visible while scrolling

  I selected this option in a report and when I try to open it from reportserver it raises this exception An error occurred during rendering of the report. (rrRenderingError) An error occurred during rendering of the report. Object reference not set to an instance of an object. Any Ideas If I uncheck this option the report renders fine, but I need to show the first column of the matrix while scrolling the report. Thanks in advance. ...Show All

• Robert Neal "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• lew26 Error in the login process when establishing connection

  Hello, I am trying to connect to a database through a web service. I am being able to connect to the databse through the server explorer in Visual Studio 2005, but when I try to do it with code in my application this is the message I get: A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host ...Show All

• JayMo setup.exe /qb REMOVE=ALL instancename=test

  Hello , I am using MSFT SQL Server 2005 (v 9.00) and have 3 databases listed under Database when I launch SQL Mgmt Studio These are: Deva, Devb, Test I have to UNINSTALL and REMOVE only the TEST instance. I did following: setup.exe /qb REMOVE=ALL instancename=test I launch the above from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap> but it does NOT UNINSTALL that TEST instance... can anyone please help me on ...Show All

• JoePD Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'

  Hi All, I built this report same way like the other reports but in different database. When preview in visual stuodio, it is fine. When deploy to the server, I got this message: Report Services Error An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'ProjectManager'. (rsErrorExecutingCommand) Get Online Help Could not find stored procedure 'sp ...Show All