gabon's Q&A profile

• SQL Server Design of Dimension table ID in a datamart - best practise

  Best practise wanted! In a datamart (DM) a fact row is linked to a dimension by a dimension ID (key). If a DM is build on top of a (enterprise) datawarehouse (EDW), and the dimension table has a corresponding EDW table with a unique ID (dummy key), will there then be any DM design conciderations for not using that EDW table key. In other words when you design the DM, should the dimensions then have there own (new) ID's regardless of you allready have modelled (unique) ID in the EDW. I have these considerations in favour for using the EDW table ID keys i a dimension: 1. Staging the DM is easy, the EDW table staging is handling the correctness of the dimension ID's. 2. Backtracing concering DM quality checking, errors and so on, ...Show All

• Visual Studio Cannot Unpin files from the command line

  Unpinning a single file from the visual interface works fine for me, but when I try to unpin a file from the command line, I get a "Version Not Found" message every time. This is a serious issue since repinning recursively against a label is not possible to my knowledge from the visual environment. Any ideas of what this could be I've unchecked the "Only allow checkouts of the latest version" checkbox in the Admin tool and even checked the "Allow multiple checkouts" box in hopes of solving this problem, but I've had no luck. Andy, I haven't been able to reproduce this. Can you provide more details about the file history and how it's pinned ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vector maths methods...

  Following a long day of writing and debugging some nasty rigid body physics code, and feeling the pain of the maths library I have to use for this C++ work, I thought I'd take another look at the XNA maths code to see if the results would be more readable (as you might hope ;). ... But my quick look at the framework docs seems to show more deficiencies than in the code I have been using all day... 1/ There is no Point3 class. This is a real pain as libraries that don't distinguish points and vectors are a right pain - transforming a point by a 4x4 matrix will result in a different result to transforming a vector. (And I don't want to resort to coding every point/vector as a homogeneous coordinate either!). There appears to be a ...Show All

• Visual Studio Express Editions Text replace with File IO of binary/text data

  Perhaps not the appropriate forum, but..... I have a need to replace text in a file with new text. The files may or may not be text files in the sense that there may not be "lines" and they may not contain printable characters. I tried the StreamReader and StreamWriter approach and the String.Replace method. It works well, except that not all the file contents gets preserved. Three bytes at the start of the file are omitted. These occur just before the CRLF characters. Can I read the file in a binary way and then use the equivalent to the String.Replace The input will no longer be a string For such issues, please use the newsgroups at http://msdn.microsoft.com/newsgroups OTP Thanks, Ayman Shoukry ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA/XACT Premortem from a programmer

  In case this is helpful to anyone, I wrote up a few things about what I've learned so far ... reposted from my blog since few probably roam there: ...Show All

• SQL Server Help batch script task stuck in a loop

  I have a .bat file that calls a script file to log in to a server and upload a file to my pub account. When I run the .bat file it just executes the command over and over and never executes the script file. Does anyone know why Am I missing something in my script or .bat file commands below my .bat file contains this--->ftp -s:script.txt my script file contains this: open myserver.com username password put W:\UPLOAD\doc.txt bye exit Thanks, Mike Looping doesn't seem reminiscent of the batch file or the script you have listed here. I sounds like it may be due to some logic in your package. Any chance this is happening in your package ...Show All

• SQL Server How to access data in a SQL Command in the OLE DB Destination editor

  Instead of blindly inserting all my data from a previous task into a table using "Table" as the Data Access Mode in the OLEDB Destination editor. I would like to join this output with a reference table and insert only qualifying rows. Question is "how do I access the data from previous task so that I can do a meaningful equijoin" I know I have to use the "SQL Command" data access mode, but what next Thanks. chiraj well, I don't see that property. What I did was I dragged the "Sort" transformation and put it between the lookup & mergeJoin and another between the OLEDB Source & MergeJoin. That did the trick. I still have to see the results. ...Show All

• Windows Forms C# drag and drop between forms

  I've been trying to figure out how to drag and drop between two forms (i.e applications in C#). I created two forms. One form with a treeview and the other form with a textbox. What I wanted to eventually accomplish was to be able to drag the node name from an item on the treeview (form 1) to the textbox (form2) Therefore, I created the first form with a treeview, a few nodes and the itemdrag event. I created the second form with the dragdrop event and dragenter event and the textbox to capture the node that was dragged over. private void textBox1_DragDrop( object sender, DragEventArgs e) { if (e.Data.GetDataPresent( typeof ( TreeNode ))) { ...e.Data.GetData( typeof ( TreeNode )); } } Is there ...Show All

• Visual C++ x64 application (VS 2005): error LNK2019: unresolved external symbol...

  Hi: I am writing an 32 bit application using VS 6.0, compile and running successfully. However, when I open the same application with VS 2005 (Team Suite), compile the same application as x64 application for target running on x64 platform, it give me some error messages related to error LNK2019. I have changed the project properties -> configuration manager as x64, updated my own .lib files path at Additional Library Directories, but I get some error messages when i tried compile it. The error messages (LNK2019) show that it can't find the function that i am calling from my .lib files even though I already included .lib path on my project properties. I feel wierd because my application can compile very well in 32bit with VS 6.0 ...Show All

• Visual Studio 2008 (Pre-release) How to enable Paging in RichTextBox

  Hi, I am trying to load an rtf document into the RichTextBox, but one I have loaded the document I want to be able to navigate the document by using Page numbers. How can I do this, assuming the original rtf document had its page size set up to letter (8.5" / 11"). I tried using ScrollToVerticalOffset with multiples of 11*96 as parameter, but was not able to scroll to the correctposition. Thanks, G rtb doesnt support the pages feature.. its more of an editor feature.. scroll to offset should scroll by the said amount ...Show All

• Visual Studio Team System ?

  . *this message is in russian due to russian-written question* , , . ( , ), "Block incremental deployment if data loss might occur" . ...Show All

• Windows Forms from string to form

  Suppose you have the name of the form : string fname = "FormSomething"; How do I create a form object with fname as name Apparently this is not enough: Form f = new Form(); f.Name = fname; Also tried: f.CreateControl(); Can anyone please tell me how to get the form object Thanks!!! Assuming you know the full name of the form (namespace & class name) and what assembly it is in you can do something like this: Type t = Assembly .GetExecutingAssembly().GetType( "MyTestApp.FormSomething" ); Form f = ( Form ) Activator .CreateInstance(t); This code does three things. First, it located a specified assembly, in this case the main executing one, you could a ...Show All

• Visual Studio Team System Ability to incorporate relational data within TFS fields?

  I would like to add role information to a customised work item. When a user is chosen from a dropdown, I would like the role dropdown to default to the chosen user's role. Currently both users and roles are defined in Global Lists, but I wondered if there was anyway that I could move to a relational model. Can this be done Yes, moving the data to a database and doing databinding is what I'd like to do. You say that SP1 will allow the creation of custom controls - is there a URL that I can follow to get some more information on this Installing a custom control on all the relevant users' machines would would be a viable option for my work situation. ...Show All

• Visual C# Status Strip Progress Bar? C#

  Hello all, I have Visual C# 2005 and I have only been working with it for a couple of days but I'm stuck. I'm trying to get my progress bar, located in my status strip to do something but I can't seem to figure out the right code for it. Could someone help me fill this in, so I can move on. Thanks for any help in advance... oops 1 more thing... it says ProgressBar1_CLICK I want the bar to load the progress of the browser as it loads web pages. So is that correct Sorry for the noob questions, just trying to learn... private void toolStripProgressBar1_Click( object sender, EventArgs e) { } Hi. Basically this is how it works. Check the "Remarks" region fro ...Show All

• .NET Development Stream

  So here is the problem . Im into techno & trance music and there is this radio stream that i like to listen to . But at work id rather not use network bandwith to get the music. So Im looking for a way to record music from the stream . I was thinking maybe to make a buffer then have my music thrown into the buffer then have the buffer saved. Ideally i would like to import the .pl file . Hit a button to start capture then a button to stop capture. Any ideas / websites ^^^ nice but i'd so much rather make it myself. I'd like to learn the workings behind it. And would use this in future work. ...Show All