Jack Stat's Q&A profile

• SQL Server Slowly Changing Dimension with ISeries data source

  I am having a hard time working with a package that uses the IBM Iseries v5r3 oledb driver as source, querying a 152k row table, running it through a slowly changing dimension task and outputting to a sql cube. When I reduce the rows queried to around 30k - 50k the package runs successfully but when the query is modified to include approximately 60k source records the data flow task fails. the error I see is [DTS.Pipeline] Error: component "Data Conversion" (322) failed the post-execute phase and returned error code 0x8007000E Has anyone run into this Brian, Thanks for the additional info. From whi ...Show All

• Windows Forms IExtender => ToolTip

  Hello Guys,  First sorry my bad English.  My question is simple: How do overrides OnPopup method under ToolTip component ThankZ Genival Carvalho SP - BR There is no such method publicly exposed so you can't.  It depends on what you are trying to do as far as where you should try to override the default behavior.  If you want to control the rendering and are using .NET 2.0 then the new OwnerDraw property and associated Draw event can be used to control how it renders the tool tip.  If you want a notification when it occurs then you can handle the Popup event.  Within the Popup ev ...Show All

• Visual Basic XML Comments: how to have them show in the properties window

  I'm currently building custom Web server controls that extend the functionality of standard controls by adding properties to them. I want to be able to display en explanation of the new property in the Properties window in Design mode of an ASP page. For example, if you drop a textbox on a page and click on ReadOnly in the Properties window, the following text is displayed at the bottom of the Properties window: ReadOnly Whether the text in the control can be changed or not. I added a new property to my control called EnterCausesPostBack and I used the XML comments. It works great with Intellisense in Source mode but it doesn ...Show All

• SQL Server Error when using VariableDispenser in a custom task.

  Hello, I am building a custom component and am trying to access variables from within it. I have the following code: Dim vars as Variables = NOTHING Me .VariableDispenser.LockForRead("User::Variable") Me .VariableDispenser.LockForRead("System::ContainerStartTime") Me .VariableDispenser.GetVariables(vars) ... ... vars.Unlock()   It blows on the call to GetVariables with the following error: "Unable to cast COM object of type 'System__ComObject' to class type 'Microsoft.SqlServer.DtsRuntime.Variables'. Instances of types that represent COM components cannot be cast to types that do not represent COM" This is on Sept CTP. Any ideas ...Show All

• Visual FoxPro can i use SQL sort by special expression?

  my user want the data is sort by the field's content. the content is "I","E","C","A" and BLANK if just ascending and desc ,it's easy. but now they want sort by this sequence "I","C","E","A" then blank so how can i do it thank you SELECT * ;       , at ( data, "ICEA " ) as _ORDER  ;     FROM table  ;    ORDER BY _order ...Show All

• Visual Studio 2008 (Pre-release) How to get the Handle of a xaml Control???

  In my project. I must pass a Handle of a control to a dll. In the previous Windows Form, it's easy to get a control's Handle. But in WPF,it is very difficult,I wander if there is a way to achieve it. Thank you!! Hi, Rob, hwnd is the only thing in WPF we can use to talk with other windows, so don't remove it , as long as the win32 is still there, we should keep hwnd thingy Sheva ...Show All

• Smart Device Development Really need to increase main memory

  Currently the emulator allocates about ~25MB of memory (storage+progeam). Storage isn't a problem since I can emulate a storage card. However 20MB of program memory is not enough for some of the applications I'm testing. Is there a way I can increase the program memory to about ~40MB Thanks in advance for the help. :) From the VS Tools->Options->Device Tools->Devices-> <device name>->Properties->Emulator Properties, select specify RAM size and specify the RAM size value you are interested in upto 256M. If you are starting emulator from command line specify memsize command to incr ...Show All

• SQL Server Nulls when summing a group in an expression

  Hi guys, I know this has been discussed before, but not in a way that solves this particular problem. I have some data in a table that is grouped by rows, but when i sum the fields in the group i am getting an error because one of the grouped rows contains a null. Now when i have a one to one relationship between a dataset field and a table cell, checking for a null is easy. But how do you do it when you have several fields that are being summed for that table cell In this particular case, i have a work around - there are only two data rows per row group (paid revenue, and unpaid revenue), so i can check them individually for nulls ...Show All

• Visual Basic How to set a control's visible property.

  I have a form that has a combo box with 7 items and also has 7 group boxes. Basically, I would like the user to click an item in the combo box and have the corresponding group box appear. If the user clicks a different item in the combo box, then I want the visible groupbox to become invisible, and the new corresponding groupbox to become visible. Could someone help me out with the code Instead of a hardcoded Textstring being used to call the DisplayGroupBox function you would use the combobox text property Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As Sys ...Show All

• Visual Basic Amazing super serious bug..

  Using 2005 RTM In our file based Webb application, we add a new page. Then we add this simple code. Dim bTest as Boolean = True If Not bTest Then   Debug.WriteLine("bTest is false") End If And Guess what, the debug line is printed. If I do a breakpoint on the If line, and add a watch for bTest its TRUE, still it goes into the if statement. Rebuilding the solution dont help. I cant replicate it on any other project at the moment, but it happens in our main development project. Any tips are welcome!! This bug seems hard to repro. But, we at MS are committed to find and fix it. We need more info on the bug. Does this repr ...Show All

• Visual Basic COM Objects in VB.NET 2.0 and their handling

  Hi, Sorry if anyone did ask that question before, I wasn't able to find it. Here is my Problem. I am supposed to rewrite an old Visual Basic 6.0 COM component used in ASP Pages in .NET 2.0 to increase Performance and to make the whole thing more extendable (we are now writing new pages in .NET so we just need some backward compatibility without having an old component and a new one) Now, where the thing gets tricky is testing. I did simply select New File -> COM Component. And.. VS.NET created my COM Guids and that stuff to have that File be compiled into a com component that can be registered with regasm /codebase /tlb But.. when IIS sta ...Show All

• Visual Studio Can't download anything

  I have just joined the VSIP to look into the amount of work needed to add another programing language to VS 2005.  I can get to the  http://affiliate.vsipmembers.com/affiliate/downloadFiles.aspx  page.  But when I click on any of the links there, I end up back at the http://affiliate.vsipmembers.com/affiliate/default.aspx  page.  How can I get the VS 2005 SDK Scott Scott, Thanks for bringing this up.  I just tried it myself and it did the same thing for me. I'll see if I can get this cleared up. ...Show All

• Visual Studio Tools for Office Install problems

  Hi, I tried to install visual studio tools for office now for about two hours and I have failed miserably. What I did was 1 Installed visual studio 2005 2 Installed office (with the .Net things for word, excel, outlook etc.) 3 Installed vstor.exe Now if I understand things correctly this is supposed to be enough. Also this would give me some office options under the new project tab in Visual studio, but no. And when I tried to open a sample project visual studio was kind enough to inform me that it did not have all required components installed. So does any one know what I need to do A qu ...Show All

• Visual C# How to encrypt a string in C#

  Specifically, I want the encrypted string to contain only numbers and letters (no special characters). Thank you! Veneta - There is an encrypt method in System.Web.Security in the FormsAuthentication class. http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfSystemWebSecurityFormsAuthenticationClassEncryptTopic.asp You can also see another example here: http://www.codeproject.com/dotnet/DotNetCrypto.asp HTH, Karen ...Show All

• Visual J# How do I remove a package downloaded by mistake?

   Hi and thanks for your help.  I have already gone to the Add/Remove and it isn't listed.  I also checked the Windows components and couldn't find it there either. I downloaded: Microsoft Visual J #.NET Redistributable Package 1.1 and my computer doesn't have enough memory to allow me to open my e-mail.  I have done everything I know to do to increase my memory, but it hasn't worked.  I know I need more memory anyway since I only have 256 MB of physical memory, but I haven't really needed more until now. I went in and did a Restore System today and I think my e-mail is now working.  Thanks again. &nb ...Show All