Answer Questions

• tocyril KPI value expressions

  I'm trying to understand what forms the value expression of a KPI can take. All the sample I've seen so far have been very simple, like a simple measure expression, e.g. [Measures].[Internet Sales Amount] I've also had success specifying a simple tuple, e.g. ([Measures].[Internet Sales Amount], [Product].[Product Model Lines].[Model Name].&[Bike Wash]) But what if I want something more a little more sophisticated For example, what if I want ...Show All

• jillab Where is the Business Intelligence Development Studio

  Hi folks, I installed SQL Server Express Advanced Edition and Toolkit. According to the documentation, I should be able to create reports using Business Intelligence Development Studio, but I can't find it. There is only a Microsoft Visual Studio 2005 menu instead. I'm just wondering if there is something wrong with my installation, or is BIDS inside Microsoft Visual Studio 2005 Any comment appreciated. ...Show All

• ChrisA Sending one message to multiple consumers

  Hi Remus What if I need multiple clients to read (RECEIVE) the same message Would it be possible Thanks Hi Rushi/Remus I tested that example, setting the same subscription from two different clients. Then I sent a publication, and read messages. For what I understand in that example when a client subscribes for a particular publication, his conversationID is saved on a table. Wh ...Show All

• Mark Arteaga_MVP Installing SQL Server 2005 Express Ed

  Hi All, I'm new to programming and I've got to develop a db for a uni project. However after downloading SQL Server 2005 express ed, I found that I could not find the command prompt to start writing scripts (black and white DOS screem). I only have the configuration tool option in my menu (within that server configuration manager, error & usage reporting and server surface area config). How do I get started with creating my database, ...Show All

• e2e TFSWarehouseDataSourceView is missing

  urgent: When trying to process the warehouse (TFSWarehouse) manually using the analysis services (in the sql server management studio) the following message is shown: TFSWarehouseDataSourceView is missing. I doublechecked and there's no TFSWarehouseDataSource in the "Data Source View" subdirectory. how can I restore or create this datasourceview I've got the schema of this datasourceView: <Create xmlns="http://schemas.microso ...Show All

• sohman How can I convert download SQL Server 2005 to a licensed version.

  I downloaded a 180 day trial version of SQL Server 2005, and have it running. I have purchased a 5 user workgroup version. I would like to apply the 5 user license to the version that is currently installed. My preference is to not reinstall everything since I have everything configured as I would like, and it is working great. What is the best approach Paul Will this leave the installed database and all ...Show All

• DBizFoShiz Truncation error arrising from quote escaped quotes in quote encapsulated strings

  Hi All, I'm having trouble importing a CSV file into SQL using SSIS. The trouble seems to stem from truncation and from quote encapsulated fields. Firstly it's worth noting that some of the data within the quotes contains the separator. E.g. 12,"some text, and a comma",34 Thankfully SSIS seems to cope with that by specifying " as the Text Qualifier. My next problem was that the SSIS Import and Expo ...Show All

• ErikH Importing tables to Microsoft SQL Server Management Studio Express

  Hello, I'm trying to import some tables from another sql server to my laptop.  I just downloaded Microsoft SQL Server Management Studio Express and i'm not sure how to import things.  Could anyone help me with that     Thanks a bunch j     Imports rely on SSIS which isn't supported in the express edition. However you can use the bcp utility or backup and resto ...Show All

• mt69 SQL Server Memory usage keeps going up using SMO

  Hi, I have written an application to preview the deatils ( columns, permissions etc) of Server/database objects (Tables, Views, Logins etc) using SMO. I have just noticed that the 'Memory Usage' goes up everytime I run the application. Once it has gone up it stays up. Even when the application is shutdown the 'Memory Usage' remains the high. What am I doing wrong Regards, Joginder Nahil www.starprint2000.com ...Show All

• thebavarian Parent Child Dimension Question

  I have a simple parent child dimension set up where the root level records have a ParentID of <null>. When I browse the hierarchy the root level appear correctly, but when I drill into one of the levels of the hierarchy, the root level element is duplicated at the next level even though there is no such relationship in the dimension. Here is a simplified example of records in the dimension: ID Name ParentID 1 Root1 & ...Show All

• CodieMorgan Cannot create a connection to data source !!!! SSRS 2005

  I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group! Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password. I thought that since this datasource was set to Windows Authentification that it would just pass it through I'm pulling my hair out at this point: Screen Shots: http://www.webfo ...Show All

• Joo Lee Export Data to MS Access file

  Hi guys, I use Data Flow Task to export data from SQL table to MS Access file. In Connection Manager for Data Flow Destination task I specify  provider "Native OLEDB/MicrosoftJet 4.0" and path to Access file in Database file name box. In design time I have no validation error. Everything looks fine. However in run time mode I'm getting error: "Error: 0xC020801C <Datataset name> , MS Access File [1459]: The AcquireC ...Show All

• Idanle "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now disp ...Show All

• nikhilkapur Stalled restore? SQL 2005 Standard Edition

  Hi we are trying to do complete restore from a SQL 2000 bak file. The file is 95GB. After running restore database statement, which took about 5 hours, the database shows status "Restoring..." And it's been the same for 12 hours so far. I checked perf mon and it shows zero activity in processor, phy. disk tranfer, and SQL restore throughput. If anyone can confirm this is normal please let me know. I may have to call MS support tomorro ...Show All

• sernamar Running a SSIS package remotely on the SQL Server

  We have a package (which uses SQL Server Destination Task) imported in the SQL Server. Is it possible to invoke this SSIS package from a remote App Server through C# .NET. We would like to execute the SSIS package in the SQL Server itself and pass on the results of execution to the calling C#.NET application via the output variables declared in the SSIS package. Thanks, Loonysan If i have to write a remo ...Show All