Answer Questions

• JaggedEdge connection string based CREATE CUBE supported in AS 2005.

  Hi, I am trying to use the CREATECUBE functionality in AS 2005 through connection string property, but getting following error: Microsoft OLE DB Provider for Analysis Services 2005: The following system error occurred: Unspecified error . csSourceDSN=PROVIDER=MSOLAP;DATASOURCE=WOTTRANSUBHSXP\DEV;INITIAL CATALOG=National; CREATE CUBE [National] ( DIMENSION [Line], LEVEL [All Line] TYPE ALL, LEVEL [Line], LEVEL [Brand], LEVEL [I ...Show All

• Brian92fs Can't start SSIS

  Hello, Our enterprise have bought a sql server 2005 standard edition. Before installing it i have installed the beta version. And after I desinstalled this beta version (with difficulties). But the problem is that I can't start SSIS. I have the following message: " The request failed or the service did not respond in a timely fashion. Consult event log or other applicable error logs for details. " Please can you help me. Thanks. ...Show All

• Ade S. Miller - MSFT VS 2005 RC and Running scripts to Create Databases

  I have started using the starter kits for the VS Products mainly the Web Starter kits. The problem I have found is that I can not use the club starter kit because the database is of an incorrect version and can not be upgraded. What I have done is downloaded the Database creation scripts from MS Downloads. Next I created the blank database, and now I would like to run these scripts against the DB that I have created. How do I run these scripts, ...Show All

• DexySeeksHelp Problems with deleting rows in destination table when exporting to Excel

  Hi, I export one table to Excel using Export Wizard. Second time I have used this creator I have checked option "Delete rows in destination table" because table already exists in Excel file. During execution I get an error: "Error 0xc002f210: Preparation SQL Task: Executing the query "DELETE FROM 'MyTable'" failed with following error: \" and here is my translation from my language: "Deleting data from ...Show All

• Jason Hayes SSIS question - database syncrhonization

  I have a requirement where in I need to synchronize my legacy Progress database to SQL Server. a) whenever a row gets inserted into my Progress tables, I need this row to get inserted into my SQL Server table as well. b) The Progress tables are not normalized. Hence, in some cases, a column in Progress table maps to 3 columns in SQL Server tables. I need to do such a mapping in SSIS. Also, I need to slice the column data from Progress and ...Show All

• Gentia a newbie question on SQL database use

  Hi there, I am a longtime programmer in OO Visual dBASE environment migrating to C#, MS Visual Studio and FoxPro 9 all at once. it is hard for me to formulate questions since I have a somewhat visceral understanding as to what I need, so I need a general advice. I am abandoning dBASE since it does not provide .NET capabilities. But I do have extensive database tables accumulated over many years. How can I use my dBASE tables for instance in this ...Show All

• Eric.d Inserting Null Value

  Is there a way, I can insert NULL value to "DT_Date" type Row Column using Script Component Transformation of Data flow Ie. I have a column named Ordered Date which is type DT_Date. Based on some condition within a script component task, I want to set the value to NULL, however, since the type is date it will not allow nulls. Found the answer, it was fairly simple. Row.FieldName_ISNULL() proper ...Show All

• Michele_T A question about group structure?

  hi, all I have one report like this: Students Scores For Class 1 StudentID StudentName Age Score........ ....... Average:....... Students Scores For Class 2 StudentID StudentName Age Score........ ....... Average:....... ... For this report, I need to show StudentID StudentName...... on every page as header, but Students Scores For Class only show once for each class. So, in this case, the structure would be: GroupHeader --> Studen ...Show All

• Leonid B SQL CE 2.0 and SQL Mobile 2005

  Hi, I would like to know if we can install both versions of mobile SQL (SQL CE 2.0 and SQL Mobile 2005) on the same PDA. I know that two versions of CF .Net can be installed. Indeed, I have an old CF .Net 1.3 application connecting to a SQL CE 2.0 database and a new one using CF 2.0 and SQL Mobile 2005. The first one will be migrated but in the future ... Meanwhile, the customer wants to run the two applications without any code modificati ...Show All

• Little_Dice Error in Registering Instance using Management Studio

  Hi, When I register instance --StockBroker, there is an error in the second step: installing Windows Service. The error message is: Required information could not be retrieved from the registry. This usually indicates a problem with setup, configuration, or security. (Microsoft.SqlServer.NotificationServices) My setup testing was successful, and I used a domain account(admin) with the domain name. What could be the problem please ...Show All

• pato SQL Server Setup unexpectedly failed (again)

  I’m running WinXP SP2 with 1GB RAM, dotNET 2.0. and a previous install of SQL Server 2000. I have tried to install SQL Server 2005 Express and it fails early in the installation: "SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file...". The log file is: (!) Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (B ...Show All

• Macrop RS Web Service

  Hi, I am getting the following error when tries to call any web method of ReportExecution2005 Web Service from a 2003 Web application. "Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/01/12/reporting/reportingservices/LoadReport ." Please someone suggest me how to fix this issue. Thanks Anobe Web Application: Its build on VS 2003. Report Server: Its RS 2 ...Show All

• bobmarble SQL 2005 & Windows Password Policy

  We run a few shared hosting servers in the UK, now we used to run mssql 2000 and moved to 2005 in december 2005. Microsoft SQL 2005                                      9.00.1399.06 Microsoft SQL Server Man agement Studio      9. ...Show All

• stangster67 Task Expression Evalutation Time

  I have designed a package whose first step initializes several variables .  Other steps in the package have expressions based on those variables. Example Expression for MyTask:    PropertyName = "Disable"    Expression = "@DoMyTask" Given this example MyTask will be enabled/disabled solely based on the value of @DoMyTask at the time the package execution begins.  Changing the value of @DoMyT ...Show All

• James.Geurts Programmatically show & don't show texboxes

  Good day! It is possible that you can programatically show & don't show texboxes in the reports Coz the user can choose if he want to view ir not the names. can it be possible thanx.... On the Visible propery you can place an expression under Hidden.. Like: =iif( expression ,True,False) ...Show All