Bernard Brisson's Q&A profile

• SQL Server Loop container to process all excel files

  What I'm trying to achieve is a SSIS package that will pick up 1 or more excel files, process the data in them via the conditional splitter, pushing the good data into a table, and all other rows into an error table. I'm having some issues using the ForEach container to process multiple excel spreadsheets into tables. The excel import into the tables is more or less working (imports data for good cases, but uses a null if the Excel Source when it gets an unexpected value - but that's a seperate problem). I found something related to this when searching, but it related to CTPs (June and September) and trying to reuse the connection strings they built up there (using my own variable names, naturally) causes a 'Property Va ...Show All

• Windows Forms What does "Control.ControlCollection" mean in the documentation?

  What do "Form.ControlCollection" and " Control.ControlCollection" mean in the FCL documentation Form and Control are not namespaces so perhaps ControlCollection is declared a nested class inside the Form and Control classes respectively Is this new to the V2 FCL (I don't remember seeing the use of nested classes much in the V1.1 FCL) Nested classes have been around for a while those 2 classes have been around sinec at least 1.1 and probably 1.0. You will see nested classes elsewere also, most notably when dealing with ListViewItem classes. you can create your own by simply doing public class myclass { public class insideclass { } } Personally I don't see the point of it and it makes f ...Show All

• Audio and Video Development Adv. Cont. Playback on HD-A1 >> NO RENDERING

  Hi All, I am having trouble getting an advanced content application to play once burned on a DVD-R and inserted into the Toshiba HD-A1 HD DVD player. Video and audio play fine using this method, but once the advanced content object is reached the player stops playback and gives an error. Does anyone have any advice on this We have tried the samples posted here and we get the same results. Thanks. I got similar results to Jeff. My first effort described above was fatally flawed as I tried to remember the disc structure from memory, and failed (I put ADV_OBJ into HVDVD_TS - doh!) This time I copied the Buttons ADV_OBJ dir to the DVD and made a blank HVDVD_TS directory at root. The player recognized it as HD DVD, but gave the ...Show All

• Visual Studio 2005 IDE: No MRU List

  Hi all This is really starting to bug me now and despite a few hours of searching I can find no solution! I installed 2005 IDE and all is working fine except for the fact that whenever a project is created, loaded or saved the Project MRU list on the start page remains empty. I have seen much about the lack of being able to remove them and checked that the appropriate registry key was created, i.e: HKCU\Software\Microsoft\VisualStudio\8.0\ProjectMRUList This key exists and yet using RegMon the IDE never seems to attempt a write to that location. What worries me is that if this is not working, there may be a few other "foibles" I have not yet found. For info: The desktop on which it was installed was instal ...Show All

• Visual C++ Link error from Command Line: LNK1561

  Hello All: I've looked at the online help pages for link errors when using the command line and still can't fix the error. I see the error relates to entry point not defined'. How do you define the entry point Thanks, PJM Brian- Thanks for your reply. Here is the info... Setting environment for using Microsoft Visual Studio 2005 x86 tools. c:\Program Files\Microsoft Visual Studio 8\VC>cl -EHsc simple.cpp Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50727.42 for 80x86 Copyright (C) Microsoft Corporation. All rights reserved. simple.cpp Microsoft (R) Incremental Linker Version 8.00.50727.42 Copyright (C) Microsoft Corporation. All rights reserved. /out:simple. ...Show All

• Visual Studio 2008 (Pre-release) Cost of Binding?

  Can anyone comment on the expense for large number (thousands) of data binds Fundamentally, what does it cost me to do a bind I already understand the benefits :-) thanks, Kiel Mike, My question is a bit more general. In my specific case I'm creating several hundred UserControls that have multiple DataBindings set directly, or through a Style and a DataTemplate. It feels slower when more items are used. I guess a more specific question would be: When using DataTemplates and Styles what cost is occured Compared to setting the values by hand. IE Width="{Binding aSize}" vs Width="100" ...Show All

• Windows Forms DataTables

  How to add dynamic datacolumns in datatable for windows application using C#. (each row should have different number of rows) For eg suppose the number of rows in datatable is 3. Then for the first row the number of column is 4, for second row the number of column is 5 and for the third row the number of columns is 2. Try to give the code or solve the query asap. Don't post your questions twice. Your first post has been answered already. ...Show All

• SQL Server Comparing dates

  HI, In my report there are two parameters,One is for StartDate and One is for enddate.Startdate must lessthan enddate.How to compare two dates in sqlserver report,and if send date is earlier than startdate how to display error message. Thanks in advance You can use the Parameters collection to reference the value of a parameter - Parameters!StartDate.Value. So you can compare the two dates like =IIF(Parameters!StartDate.Value > Parameters!EndDate.Value, "Error", "OK"). ...Show All

• SQL Server Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare for Execute (Success) - Pre-execute (Success) Messages Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started. (SQL Server Import and Export Wizard) - Executing (Error) Messages Error 0xc02020a1: Data Flow Ta ...Show All

• Visual C# Force Application Shutdown

  I want to be able to shutdown my application from within the MyApplication_Startup method (if they are not running a legal copy) BEFORE the main form shows but I cant seem to force it to do so. Any ideas ...Show All

• Visual Studio Express Editions vb express code snippet problem

  I am trying to work through the "Visual Basic 2005 Express Edition for Dummies" book. I have installed VBE on 2 machines. Both seem to have corrupted code snippets. This is all I get when I insert the code for the mortgage calculator: Dim futureValue As Double = 0 Dim payment As Double payment = Pmt(0.05 / 12, 36, -1000, futureValue, DueDate.EndOfPeriod) Shouldn't there be more Am I missing something Thanks. It is possible that the book writers had some 'beta' or pre-release information/files from Microsoft that got changed before the release of VB EE. Maybe Microsoft re-thought how snippets would be used and trimmed them all down. ...Show All

• SQL Server Report Builder Formatting Currency

  Hi all I need Report Builder to format Certain Numbers as Currency by default. According to the documentation I need to set the culture setting in the report's datasource. I'm using a SSAS2005 Cube The Report Manager then let's me create the Model wich is used by Report Builder. My Question is: Where do I set the culture setting I cannot find it in the Cube and viewing the model's xml hasn't helped. Any help will be dearly appreciated G http://localhost/Reports/ click on Your model name Properties Tab: General DataSources Security ...Show All

• Visual Studio Team System Time Stamp in Source Control Explorer

  Hi, How can I add timestamp column in TFS Source Control Explorer It was so easy in VSS sort latest changes by timestamp. I refuse to beleive that VSTS miss this part!!!!! If you want this feature, you can vote for it on Microsoft Connect. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=727904&SiteID=1 Regards, Grant Holliday http://www.oztfs.com/ ...Show All

• Visual C++ unresolved external symbol __invalid_parameter_noinfo

  Hi friends, We are building a sample project in debug mode with release build of library say test.lib we got error like "error LNK2001: unresolved external symbol __invalid_parameter_noinfo". Can anybody give solution for this problem Regards, Mukilan You said, " It's *possible* for an application / library combination with mixed CRT to run, but I'd say that depends entirely on the symbols used." Would you care to explain how something like this is done I'm facing the same problem. My application statically links to a lib that is given to me from a 3rd party. They only deliver linked library which was compiled with /MT. I want to debug my own code, I don't care about ...Show All

• SQL Server Multi-value parameters returning 'ALL' or an itemized list

  I work in the Data Warehouse where like in most large companies we run very long and complex SQL with lots of data in parameters are datasets. Due to the nature of our SQL I need our multi-valued parameters to return (something along the lines of...) ‘ALL’ if all values are chosen or an itemized list (as it already does) only if not all values were selected. The SQL would look like this... where ‘ALL’ in (@PARAMATER_NAME) or table.field in (@PARAMETER_NAME) I can not seem to find anything about this online, which I would assume is a very common issue. Can anyone help me with functionality As mentioned in the prior post I write similar syntax, however, something of a min ...Show All