Answer Questions

• patternagnstusr split address into multiple field

  i want to write a code that can split the addresses into multiple fields. anyone can point me out where to start lets say i have "12 north plaza boulevard apt.16" and i want it to become: address_number 12 suffixA North street_name plaza blvd suffixb apt16 Sorry, this is hardly possible. Thats like telling which 3 figures where summed up to get the result of 16 After a aggregation is hardly possibly / impossible to split up the aggregated value, because you do not know where the Street Adress starts and ends. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• dlw10023 Login failed for user 'Domain\userId'. [CLIENT: <local machine>]

  I have a strange problem. I have installed sql server 2005 w/ SP1 (developer version) in my local. After the installation the event log shows the following error message: 2006-10-25 01:25:27.59 spid9s Clearing tempdb database. 2006-10-25 01:25:27.89 Logon Error: 18456, Severity: 14, State: 16. 2006-10-25 01:25:27.89 Logon Login failed for user 'Domain\userid'. [CLIENT: <local machine>] 2006-10-25 01:25:28.09 spid12s Starting up database 'msdb'. (Obviousely, I have removed my id for security reasons) The real problem is that I couldn't connect to local or any remote servers using my Sql Server Management Studio . I have spent a lot of time on the forum(s) to find an answer, but seems to me that it is an "unknown" ...Show All

• stlinarus Object taken by Microsoft.ReportDesigner.Design.ExpressionEditor.EditValue()

  Hello! I would like to use the Microsoft.ReportDesigner.Design.ExpressionEditor.EditValue(IServiceProvider provider, object value) method. My problem is that at the moment I don't know what properties/fields the object value has to have so that the Expression Editor recognizes that it is associated with a RptDataSet when I click on 'Fields'. I've spent a couple of hours trying to guess the properties/fields without success. Can anybody please give me a pointer Many thanks! Christopher, the sample code (from the Polygons sample) contains the line newValue = ( string )editor.EditValue( null , this .designerComponent.Site, this .oldComboValue); whereby oldComboValue is a string containing the previous expression ...Show All

• MIKE DANAHER SQL Express user permissions?

  I'm trying to build a web application using SQL2005 Express and Visual Studio Express.  It all works OK on the local machine, but gives an error "Login failed for user xxxx\ASPNET" when used remotely.  I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please Thanks John Hi Laurentiu I've issued the CREATE USER for every database in sight, and I've also used ssme to look at the USERS for each database and ASPNET is there, and it seems to have CONNECT permission ... As to using some other tool to connect to the database - what do you suggest John Have you tried connecting to the database as ASPNET using some other ...Show All

• K.S.RamakrishnaPrasanna Daily use of encryption

  In practice, I find encryption kind of messy to use -- opening, closing keys, use of certificates, all the while trying not to give away the password in cleartext. If our .NET programmers are to use it efficently in high-level code we need a function call, say "EncryptValue(<input value>)", that simply returns the encrypted value. Is it possible to write such a function (And of course, we need the mate "DecryptValue(<encrypted value>)". TIA, Barkingdog [edit] re-wrote the below :) It's hard to say without knowing more details of your application but I would generally recommend you do this external to the procedure.  It's better for performance, as yo ...Show All

• Darius R Decimal places in Node_Description??

  There's been several good posts on using the node description of a model as the end user description for a specific cluster. My model uses a number of continuous input columns defined as currency from a fact table in the source cube. After processing, the node description has elements that look like this: -0.5799759795 <=Interest Expense <=0.8397462488 , Since the source data is currency, this makes the node description look a little strange. The data type in the model is set as double. The precision implied by the description is not what I want the model to consider. In the case above, the difference between the numbers listed is not significant. It would be great to have a better node desciption that do ...Show All

• WedgeSoft SSIS Access import to SQL Server 2005

  Hi, I have created a SSIS dtsx package file on my file system that I want to manipulate in .NET The package gets an access DB file and the a Preparation SQL Task creates the necessary sql statements for the data flow task. The data flow maps the tables from the source to the destination and then if you execute the package, it copies the Access DB into SQL Server. My problem is, I want to manipulate this package in code, so that I can change the path to the source Access DB and then re execute the Preparation SQL Task so it recreates the new SQL statements, and then I want to update the data flow so that I it uses the new SQL and creates the necessary tables. How is this possible in .NET I have looked everywhere and have found some topics ...Show All

• Haim Cohen Error when hiding subtotals in Report Builder

  I consequently get an error message in Report Builder (version 9.0.2047.0) when I make a report without subtotals when I have the Key attribute of a dimension in combination with a measure. The following Report is OK, but when I unselect Show Subtotals, I get an error message. Date | Count Result ------------------------- 10-10-2003 | 200000 ------------------------- Total | 200000 The error message is: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred during report ...Show All

• WilliamDGJones Error - The report server cannot decrypt the symmetric key?

  SSRS had been working fine on my comp till the time i insatlled VS 2005. I have started getting following error since VS2005 install The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check the documentation for more information. (rsReportServerDisabled) Get Online Help Bad Data. Why does this error cropped and how can i fix it I am using SQL Server 2000. Thanks Incorrect. Only the ecrypted information will be nuked, i.e. connection credentials, connection strings, and any secure information stored in subscriptions – by default this is only username & ...Show All

• RussellH How to rename a table ?

  Hi all. I'm porting an application from eVB-ADOCE to VB.Net-SQL CE In the old application there are some SQL statements like this: "ALTER TABLE OldTable TO NewTable" Is there an equivalent instruction or a simple way to rename a table I was not able to find anything simple to do the same. I really need NOT to do something like SELECT * INTO NewTable FROM OldTable because the resulting table could go outside memory and/or spend too much time in elaboration. Please let me know what I can do. Many thanks ! Don't worry - I'm working on an article that will allow you to do this from .NET CF on a device. I will post this article either today or tomorrow. This is very interesting, and ...Show All

• Six Combining multiple subreports into a single report

  The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report that contains them defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over producing blank pages. Are there any work-arounds to concatenate multiple, single report PDFs into a single PDF and have page numbering too Thanks! Hi, The mechanism that we've used to achieve this is to write some code using a PDF library to combine the reports. It goes off and renders the reports and then adds them to a master document. That way we can add page numbers, table of ...Show All

• Dean Johnson - MSFT Trying to get the remainder of a decimal by using Formula on a field

  Hello Everyone, Here is my situation. I have a field in a table (named QuestionPosition)(type Decimal) that contains values like this: 1  2   3  4  5.1  5.2  5.3 ... I want to have another field in the same table that stores just the remainder (in the above case a 0 for integer values and the 1 of the 5.1, 2 of the 5.2 etc. I created the field in the table (named QuestionSubPosition) and tried to set the formula for it to QuestionPosition % 1 but it does not accept the formula. The part that i do not understand is that i can set the formula to QuestionPosition / 1 it works (but not the results i want). Any ideas on how i can get the results i want Corey ...Show All

• fasttrack Variables in Script Task

  I recieve the below error when I attempt to execute a Script Component in a Data Flow Task: The collection of variables locked for read and write access is not available outside of PostExecute. This is the code I used: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) Output0Buffer.AddRow() Output0Buffer.BillerId = CType (ReadWriteVariables( "CustId" ).Value, Int32) Output0Buffer.UserAccount = CType (Row.Column0, String ) Output0Buffer.UserS ...Show All

• HowardCarr SSIS adminsitration Website

  Hello everybody, I've been working with SSIS for some weeks now and there are some Items that I really miss compared to for example BO Data Integrator. One of these is an Administration Console for SSIS packages. These would list all the jobs currently available in the repository: should be on file system and SQL server and give the user the ability to aunch them manually (in case of a job fails or something like that...) Another feature this admin console should have is give the user a status of the running packages much like in SSIS designer when debugging packages. Now I'd like to develop this by myself but I can't find any information about the Namespaces, Classes and objects I need to develop such an application... Doe ...Show All

• Exclude Running SMO inside a SCRIPT TASK

  Dear folks, I'm trying to call SMO classes from SSIS package but I don't know which reference to use.. Mighn't be Imports Microsoft.SqlServer.Management But Intellisense don't give me such info. Let me know where I'm failing. TIA http://www.google.co.uk/search hl=en&q=smo+namespace&meta = -Jamie !! thanks a lot!!!!!!!! you must be tons of patience thanks Jamie, It seems that must be moved some assemblies to \Microsoft.NET\Framework\v2.0.xxxxx in order to acquire its full features from a package. Definately definately not! thanks for the response but I don't get the point colleague. What do you mean in design-time I want to instantiate SMO classes from Script ...Show All