DarrylW's Q&A profile

• SQL Server Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All

• Visual Basic Conditional Compilation

  Hi, I have a number of projects in my solution and I use Conditional Compilation in a number of places, I would like to share Constants between projects, so I don’t have to define and undefined the same Constant in a number of projects. Can't seem to find a way round this. Any comments appreciated Thanks You can define constants so that are accessible by the entire project, by doing the following in Visual Basi ...Show All

• SQL Server SSIS Configurations XML file not being used

  I have specified the location and altered the values of the configurable properties in the configurations file at deployment time using the mainifest. When I run the package I specify the configuration file to use on the Configurations tab of the run package dialog. Unfortunately the configuration file is not read (even though it is in the "Command line" statement). When I execute, the configurations are still read from the location ...Show All

• Windows Forms Unexpected handling of \r\r\n sequence in RichTextBox

  A rich text box with the string "abc\r\r\ndef" displays it as "abc def" (visually replacing the \r\r\n with a single whitespace character). A *text*box with the same string displays it as 2 lines, what I expected. This happens with .Net Framework 2.0. Is this a bug Is \r an RTF sequence of some sort Neither the control character itself nor the 2 character (backslash 'r') are listed in http://msdn.microsoft.com/library/default.asp u ...Show All

• .NET Development ICertificatePolicy overriding is not being called

  I'm overriding the ICertificatePolicy to have a custom certificate validation. When this class is overriden you must to implement the CheckValidationResult where the custom validation is performed. When I started using the code (it is a little more below), It seemed to work fine, but I just realized that is not  being called all the time. Sometimes the CheckValidationResult   is called, but other times that is not happen ...Show All

• SQL Server Customer Count

  Hello, I have a Fact table containing sales information, and is linked to a customer dimension through a CustomerKey and to a product dimension. The Customer Dimension is a slowly changing dimension having CustomerKey as primary key and CustomerPIN as BusinessKey. A customer can have historical records in the Customer Dimension. I want to count the number of clients per product. If I create a measure Customer Count as Distinct Count on the ...Show All

• SQL Server Association algorithm - Importance of a rule

  Can anyone tell me, how the Business Intelligence Studio calculates the importance of a rule. I can't find the formula. I know some formulas, but the result in SQL Server is completly different. Thanks! For rules, the importance is calculated using the following formula: Importance (A=>B) = log ( p(a|b) / p(a|not b) ) An importance of 0 means there is no association between A and B. ...Show All

• SQL Server SSIS Flat file connection manager not seeing carriage return-line feed

  I have a csv file as follows: "100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb "100,002.01","200,00.01",10.98,aaaaaaa,bbbbbbbbbb "100,002.01","200,00.01","1,000.98",aaaaaaa,bbbbbbbbbb Note that the third column in the third line is also qualified by quotes whereas the previous two are not. I think this is because of Excel formatting. Is there any way to import this file correctly My main problem is that I never know whether a  ...Show All

• Visual Studio Express Editions C# compile a final release

  I am new to this c# thing and I have been using the C# compiler to run my programs. And just realized that I don't really know how to make a final project. Does the computer that I put it on have to have .net 2.0 And if so how do i include that in the installation And what do I do about the dlls do i just leave them in the directory or do I have to register them with windows. Thanks in advance. hi, //Do ...Show All

• .NET Development Is there not one single example like this in the WORLD?

  Hi all, Examples are usually the best way to learn. So what I don't understand is why there isn't an example of what I need anywhere in the world! Or is there What I need is this: A *complete* (end-to-end) example of a database driven Windows application. It can not be based on datasets as they are slow and not built for object oriented programming, nor are they suitable for large applications. I need an OR mapper tool to help out. The exa ...Show All

• Visual Studio 2008 (Pre-release) MessageContract Deserialization error with IIS hosting

  Hi, I'm having a strange problem. A simple operation with a simple MessageContract works just fine when the service is self-hosted. But when the service is hosted in IIS, I get the strange exception below.     public class FooParamsIn     {         public long ID;     }     public class FooParamsOut     {   & ...Show All

• Windows Forms TabControl / TabPages and control events when edit via PropertyGrid

  Hi, I'm writing an app that has a limited designer mechanism... I ran into a small problem.  When you add TabPages to a TabControl via the property grid, the ControlAdded / ControlRemoved events fire many times.  This is a problem for me because I have an event-based Undo / Redo system, and I'm recording extra events.  I understand why the events are firing extra times:  so that the TabControl can repaint while the ...Show All

• Visual Basic Ingres ADO question

  I'm creating a VB.NET (2005) app using Ingres r3 as the backend db. I'm using the Ingres ODBC driver and ADO from Microsoft. I can read data from the db with no problem, but I can't write it back. (err msg says it is a read only driver, but Ingres tech support says it's a read/write). Anyone trying to do the same thing Hi Tarne, I am sorry if I made any confusion. This is the general troubleshooting steps. A ...Show All

• SQL Server Configuration Manager ?

  Each time you start a SSIS project you have Solutions Configuration showing "Development". In the drop down box you can select "Configuration Manager..." Can someone tell me the use of this, and is it related to the package configurations somehow. I've tried to create new Solution Configurations like "Test" and "Production" with the purpose of binding different configuration files and deplymentfolders to each Solution Configuration but still ...Show All

• Visual Studio 2008 (Pre-release) Why can't I use Kerberos with Transport security mode?

  Problem: If I use <security mode="Message"> then I get a Kerberos token at the server. If I use <security mode="Transport"> then I get an NTLM token. On both occasions I have the client set to use "Windows" as it's credentials. Any ideas OK, the service is unable to prove to the client that it is who the client thinks it should be... I think we need a bit more ...Show All