Answer Questions

• sergun Error using neural network mining model viewer

  I've successfully created and processed a very simple neural network mining model (defined against a cube). However, when I go to the model viewer in BI studio, it displays the following error: "Execution of the managed stored procedure GetAttributeScores failed with the following error: Exception has been thrown by the target of an invocation.Input string was not in a correct format.." Any ideas about what's going wrong This is with SQL Server 2005 SP1. Hello, Some issues with the neural network viewer were fixed for Service Pack 2. You can download the latest technology preview (CTP2) for SP2 from here http://www.microsoft.com/downloads/details.aspx FamilyID=7A9AD90F-7F95-4369-A206-E84053D ...Show All

• Muhammad Imran Zafar Error: 'The DbpropMsmdMDXCompatibility property is not overwritable'

  I am getting the error: "XML for Analysis parser: The DbpropMsmdMDXCompatibility property is not overwritable and cannot be assigned a new value." when I try to connect to an AS2005 cube through http using Office 2007. I can connect to the same cube fine with other clients. Any ideas how to approach this issue MDX Compatibility Mode is a session property and cannot be changed from command to command. What you describe here sounds like a bug inside connection pooling in msmdpump.dll - perhaps somebody connected with non-default value for MDX Compatibility Mode, and his connection is being reused for your session. ...Show All

• sham_huss DTS import problem ( from excel into database)

  I have a table structure like ID int zip varchar(255) the zip code values in excel can be either 10 digit (08830-2345) or 5 digit (08830). null zipcode values are inserted into database for records with 10 digit zip code. I think its because of the hypen "-" character. 5 digit zipcodes works fine. Any ideas... this article doesnt help me... I am not sure if this solved the actual problem, but there was a similar thread yesterday: http://support.microsoft.com/default.aspx scid=kb%3bEN-US%3bQ194124 HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I don't have access to SQL Server now. ...Show All

• CaveDrake Draw Bitmap from Points in report

  Hi, i have a database field that has a drawing stored as points, for example.... (x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2)(x1,y1)(x2,x2) In my VB.NET application, i can take those points and recreate the image. I need to do the same in reporting services... i am trying to replace a legacy ACCESS report, that had the drawing object. How can i recreate the image in reporting services is there an easy way to do so i believe i tried to create a class and tried to reference it and call the function to return the data as an image, but i got a system.drawing not found error... Make sure you have copied your assembly to the C:\Program Files\Microsoft Visual Stu ...Show All

• KrisFB_APPS Referencing and renaming tables..

  help how to reference n rename table.. is it possible by code the rename option isnt available when i roight click the table referencing ... To reference a table from another database in the same server, simply prefix the table with the database name. In other words, use the 3-part naming convention of the table. To illustrate, to select from the [dbo].[Authors] table in the pubs database from the Northwind database, the SELECT statement will be as follows: SELECT * FROM [pubs].[dbo].[Authors] Hello! I have problem with sp_rename: I do us follows: EXECUTE sp_rename N '[emma].[dim_model_tmp]' , N '[emma].[dim_model_tmp2]' The table [emma].[dim_model_tmp] disappea ...Show All

• mahima easy questions related with A-P cluster

  Hi everyone, I'm just a newbie with clustering. We've got a 64-bit A-P cluster running with Sql25k 64-bit too. Each node own two local network adapters. One of them (the one currently is Active) own three IP and the another one only one. Why From CLUADMIN I see as one of these three is set as Cluster IP Address in Active Resources. So I see the following configuration for the Active node: Adapter 1: IP public for Active Directory Adapter2: IP1 (reserved or ) IP2 (used as SQL IP Address 1 in Active Resources) IP3 (used as Cluster IP Address in Active Resources) Passive node: Adapter 1: IP public for Active Directory Adapter2: IP (only have one ) ...Show All

• Sassie Setting up MSSQL 2005

  hi all, My company has finally decided to go with MSSQL 2005. now i havent used mssql since version 7.. which was a while ago.. whats the difference in terms of the setup and the easy of use Thanks Samuel. will do.. at present this company here uses msde for the backend for their application.. what books or online resources would you recommended for the new MSSQL 2005 I'd suggest downloading the evaluation version and playing around with it. The entire product has made some big strides since 7.0. :) http://www.microsoft.com/sql/downloads/trial-software.mspx You could also download Books Online documentation and read about installing & setting up your server. Thanks, Sam Lester For DBA's I recommend S ...Show All

• Carl Bruneau Another flat file parsing problem

  Hello All! I know this has come up before and I have tried several of the solutions found within the forum but I just can't seem to import my file correctly and could use some input, please. Sample file (less fields than actual file): Name (str), Phone# (str), Description(str), Resolved(bool), Met(bool) "Kay, Mary","123-4567","Used a "."not a"," in text", "1", "1" The text is qualified with " and columns delimited with commas but the description field has embedded quotes and commas. Normally it works except if there embedded quotes and commas. I have tried unqualified data and undouble, but that does not work either because of the embedded commas ...Show All

• jkeele Trigger not executing

  I will try to keep this as simple as possible and make a long story short. The college I work for has bought a third party package to basically run the operations of the school. There is a component for registration, admissions, billing, etc. It also has a web component so students can access their school information from anywhere. The backend for all of this is SQL Server. To make things easy, the vendor has provided us with the steps to bulk load users, via DTS, into the system and create their accounts for the web portion. The way this works is as follows: I create a CSV file which I then load via DTS into their "Bulk Load" table. This table has an "on insert" trigger that fires off when the load happens on the &q ...Show All

• orent sql2005 database restore from another sql2005 backup file error.

  hi i try to restore a bak file from another sql2005 server to my sql2005 server, but it show the error message as below :     TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\backup.bak'. Operating system error 5(error not found). RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399& ...Show All

• .net sukbir Exporting data to a fixed-width flat file

  Hi, There's a lot of information on importing data from text files, but not a lot on exporting data to text files... I've checked but found no info on this. I'm trying to export data from SQL Server to a fixed-width flat file and wondering if I'm doing it the right way. I use a view as source (using a OLEDB connection manager) and I can see the data without problem. I defined a Flat File Destination (using a flat file connection manager). When setting up the flat file connection manager, I am asked for a file... Does this mean one should create manually a template file with the desired output format So I used a production file as template since we're replacing an existing process. After having set up everything, I run the SSI ...Show All

• SolveIt The attribute key cannot be found - two cubes - different results

  I am working with a cube that was built by someone else.  I reverse engineered it to create a project and I am trying to re-deploy it in a development area.   I keep getting the ‘The attribute key cannot be found: …’ error on a fact table key.   When I use a SQL script to check if there are any missing keys in the dimension table they are all there.   I have tried dropping the dimension from the cube and adding it back and changing the DSV from table to Named Query.   Nothing fixes the problem.   As a test I created another project and included only the fact table and the ‘problem’ dimension and I was able to successfully process the cube ! !   I would rather not ‘ignore the errors’ ...Show All

• Mark A. Richman SSIS Configuration when deploying to production

  We are having some issues with the .dtsConfig file, and I was hoping someone could help us out. Here's the scenario: In the design of the package, I go to SSIS >> Package Configurations... In the window that comes up, I enable package configurations, then I select Add, and walk through the screens that follow, selecting my connection managers as items I want in the config file. The config file gets created with no problems, and when I build, the dtsConfig file is put into the same directory as the SSISDeploymentManifest file. When I go to the server that I am deploying to, I double-click on the manifest, and walk through the installation (MSDB installation) of the package. When the window comes up with a drop-down of all config fi ...Show All

• Ants Hurdley RS in Sharepoint 2007

  Sharepoint Server Portal 2007, MSSQL 2005, Reporting Services When I try to integrate Reporting Services in Adminitsrator, for url of RS I write this: http://servername/ReportServer/ and click OK. But when I try to go to 'Set Server defaults' or 'Managed Shared Shedules' I get this: Server was unable to process request. ---> Client found response content type of '', but expected 'text/xml'. The request failed with an empty responseWhat should I Do Hello, Unfortunatelly I face the same problem. I just put a little bit more info. In the "reporting service" area of the application management, there is 3 links: Manage integration settings : I put the url of my repor ...Show All

• mahima Deploying CLR sps or functions which call a web service to a production server

  Dear fellow developers, I have successfully developed a Transact-SQL stored procedure which calls a CLR function, which calls a web service. I am using a Visual Studio 2005 SQL Server Project to perform the necessary magic. Is there a neat way to deploy this stuff to a production server It is bad enough deploying the sp and function, but the web server proxy also needs to be changed to refer to the production web service. This all looks very nasty and complicated. Am I missing something Dear Miguel, Thanks for the suggestion. I seem to have run into a more fundamental problem. On my production server, I cannot install an unsigned assembly with external access rights, despite the fact that the database is truste ...Show All