Answer Questions

• Ariel Valentin sql command oracle oledb connection - parameter issue

  I need to extract rows using date as parameter... where source contains millions of rows but few thousands per date. I tried using SQL command in data access mode in OLE DB Source Editor but having problem with passing parameter... Anyone has solution Its nothing to do with Microsoft. If Oracle's driver doesn't work then its Oracle that needs to fix it. -Jamie Yeah, follow this: http://blogs.conchango.com/jamiethomson/archive/2005/12/09/2480.aspx -Jamie That is good workaround... but any straight solution There should not be an issue with the Oracle client version. To speed up the read, create a bitmap index on your date column on the table. Jamie, Any idea if or ...Show All

• cpaesano Format a number for use as number in Excel

  I want to format a number like "#,##0.00" in order to handle it in Excel as a number (i.e. compute a sum). Excel is able to show a number in a specail format and still allow to compute with ... Thanks in advance, Peter What problem are you having If you have #,##0.00 set as your format code, you should be able to export to Excel and then do a sum on that column. Jarret It doesn't work in my Excel neither with 1 value nor with many values - the sum is 0 anytime. Peter I found this on another post ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1072895&SiteID=1 ): Apply formatting using N in ...Show All

• Sekar1979 What SSIS components must be loaded onto the server?

  What SSIS components must be loaded onto the server To run an SSIS ETL program, exactly what executable, components, programs, etc. must reside on the server that will be running the program. Our developers write an test their ETL programs locally, on their desktops or laptops, but must upload the scripts to the production server for execution. Obviously, they are not going load Visual Studio and SQL 2005, etc. up to the server just to run the scripts (tho SQL 2005 may be on the same box as one of the DB engines used for ETL). Any info would be appreciated. hi Craig, I have installed the SQL Server 2005 Express Advance edition on Windows 2003 Standard Server. I did the full installation i.e., installed all compone ...Show All

• BluEarth Software Check all databases for file space used

  Hi There As part of monitoring i want to hourly check the data file percentage used for each database, to monitor growth and know in advance when a data file will be full. However i do not want to write a job for ever single database , this instance may have up to 100 databases that = 100 jobs. So i want to write a job that checks the percentage space used for all databases. My first dilema is that i cannot loop through databases dynamically, by that i mean if i use a cursor that loops through database names, and i dynamically build sql the say 'USE @DBNAME' and execute it the cursor context stays local you do not actually change database context. So how do i loop though databases, i have found sp_msforeachdb, however th ...Show All

• tkrasinger SSAS YTD with Multisets

  Hi All, I'm not that well versed with MDX (I'm more of a TSQL guy). I have a simple calculated member as below: AGGREGATE ( PeriodsToDate ( [end_date].[Financial].[FYear] , [end_date].[Financial].CurrentMember ), [Measures].[ActualVolume] ) This works fine if I filter on the year or a single period, however it fails if I try any mltiset selections (for example 2 quartuers). Any help would be appreciated. thanks, Hi Mosha, I'm also very interesting in solving such problems. I have a couple of CM, that use PeriodsToDate. By multiselect on the time axis some CM schould be calculatated for the first, some for the end, and some as average of YTD of every month. Today I pro ...Show All

• VRATZ Mining structure has to contain at least 2 mining models to see their accuracy charts?

  Hi ,all here, Thank you very much for your kind attention. I just found that I am not able to view the accuracy chart for my mining model. The error message is: no mining models are selected for comparision. Which is quite strange. Any guidance thank you very much. With best regards, Yours sincerely, Can you provide more details The only scenario I can think of where this would happen is where the first model was a clustering model that had no predictable attributes. The accuracy chart is only useful if your model has a predictable attribute (column), and the accuracy of the prediction can be evaluated against some test data. If your clustering model does not have a predictable attribute, the accuracy chart can ...Show All

• Omar Fawzi SQL Server 2005 Everywhere Edition: Replication with MS Access?

  Hello @all, does anyone know whether a SQL Server 2005 Everywhere database can be replicated with a common MS Access database Is there any possibility to synch a database on a mobile device (SQL Everywhere) with a central database on a server computer (like MS Access or SQL Express) without having to use a full version of SQL Server Replication is just needed for merging a small database (4-5 tables) so I think the full version of SQL Server is a little bit oversized for this issue (and too expensive, too). Thank you very much in advance, Tim Microsoft is also going to provide a solution where a SQL Server 2005 Everywhere database on a mobile device can be synchronized with a MS Access on the de ...Show All

• Chris Dunaway Word Wrap database query results

  In Visual Studio 2005, when you are looking at the results of a database query, or table (show table data) etc., how can you make the results field values wrap like we use to be able to do in VS 2003 and in Visual Interdev. If the field values were longer then what was display in the grid output results, you could expand the column width and row height and the field values would wrap to fit. If I try to do the same thing in VS 2005 or in sql enterprise manager 2005 the field values don't wrap, they remain displayed in one long line and they just get cut off after a specific number of characters. I have noticed this problem also. Until they get if fixed, just tab to that cell (all the data should be ...Show All

• Amos Soma Report Server Stored Credentials

  I am getting the standard "Subscriptions cannot be created because the credentials used to run the report are not stored -".I tried to store them in the Stored Data Source in the Visual Studio Project and then deployed. I cannot find in any documentation a reference where to go to STORE CREDENTIALS for a Report Server subscription. I would really appreciate any help on this. I did look at the existing threads, but they don't specifically address where to create the credentials. Thanks for any help you can provide. Hello Gary, Using Report Manager, drill down to your report. Click the properties tab, then select 'data sources' on the left side of the page. Make sure the 'A custom data source' ...Show All

• vgta Aligning objects

  Hi - I am using a matrix which expands dynamically, adding columns depending on my data. I want to display an image above the last column of data. Anyone have any ideas how to achieve this The image is wider than the column width so placing it inside the matrix is not an option. Thanks in advance Brian ...Show All

• Hans1982 Object reference not set to an instance of an object. MSSQL server report builder

  When I try and run Report Builder Reports i get this error message "Object reference not set to an instance of an object. " I can run reports locally but not from Report manager here is the stack trace info Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] Microsoft.Reporting.WebForms.WebRequestHelper.GetExceptionForMoreInform ...Show All

• Sukanya During processing - error in Event Viewer only?

  A cube I'm trying to process is consistently failing ("the process completed with failure."). Since no specific error was given, I checked the event viewer and noted this for MSSQLServerOLAPServices: "OLE DB error: OLE DB or ODBC error: Invalid object name "SiteAccountProfile"; 42S02. SiteAccountProfile is a table I query from in my DSView (and it's also a dimension table), but I can't imagine what the error is referring to / complaining about. Anyone know what this might mean Okay, more tinkering yielded this nugget: "SiteAccountProfile" is used as a reference dimension (IE another dimension uses it as the reference dimension) on several measures. On a particular measure (this happened to be ...Show All

• code jockey Dervied Column - Expression?

  Hi: I have a Dervied Column Component, in which there is a column called RecStatusCode. The criteria to give a value to that column is below in SQL: (SELECT CASE CertParticipant WHEN 'Y' THEN 'C' WHEN NULL THEN 'A' END FROM [dbo].[SchoolCertRequest] WHERE SchoolID = (SELECT SchoolCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) and SchoolBranch = (SELECT BranchCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID) AND LoanType=(SELECT LoanApplicationTypeCode FROM [WebStrategy].[LAF].[LoanApplication] WHERE LoanApplicationID = @LoanApplicationID)) My question is how can I use this SQL in that expression field, or is it possible to have a u ...Show All

• patrick anguet error "cannot open database requested in login 'xxxx'. Login fails"

  I build an application using Vb 6.0 SP6 with MDAC 2.8, Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A. In some computers that I installed the app, when it is launched I get the following error: "cannot open database requested in login 'xxxx'. Login fails" I'm using windows authentication to connect to the database any ideas There can be many reasons. I suggest you start here: http://support.microsoft.com/kb/827422 ...Show All

• NetPochi Cannot install Micorosoft SQL Server 2005 Books online (April 2006)

  I cannot install Micorosoft SQL Server 2005 Books online (April 2006), it appears a message of error code 2755 and another message "cannot open specified device or file..." It happens after I have installed Micorosoft SQL Server 2005 Express Edition on my Windows XP SP2 PC. I tried several times without success. Would you give some hint to fix it The most common causes of this error are: The user is not an administrator The installation is happening from a mapped drive over Terminal Server, There is an issue with the Windows Installer installation. Here are some possible resolutions: Make sure to log on as an administrator before installing the MSI. ...Show All