Kurre A's Q&A profile

• SQL Server SCD and populating dimensions and facts

  Hello, This is my first task in attempting to populate a fact and dimension table from SSIS. I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row. I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer dimension. I am filling the customer dimension by using the slowly changing dimension. If I have 2 records having same BusinessKey but each with a different first name, where first name is set as a ...Show All

• Visual Studio Problem with loading symbols for some files ?

  I have downloaded full symbols pack for WinXp Sp2 from microsoft site and added symbols directory in VS options but when I run my application I can see that some symbols are not loaded: '01 ErrorShow.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', Symbols loaded (source information stripped). '01 ErrorShow.exe': Loaded 'C:\WINDOWS\system32\user32.dll', No symbols loaded. '01 ErrorShow.exe': Loaded 'C:\WINDOWS\system32\gdi32.dll', No symbols loaded. '01 ErrorShow.exe': Loaded 'C:\WINDOWS\system32\msvcrt.dll', Symbols loaded (source information stripped). Why is this happening btw. I tryed to add symbol server but this ...Show All

• Visual Studio Team System Task "WSS.WssPortal" failed exception while importing the process Template

  I exported MSF Agile process template successfully at my local drive and then  I tried to import the same . I got a import failure message with the following exception. Can anybody tell me that what may be the reason for that failure. Event Description: Task "WSS.WssPortal" failed Exception Type: System.Net.WebException Exception Message: The request failed with HTTP status 404: Not Found. WebException: Response Status Code: NotFound WebException: Response Status Message: Not Found WebException: Status : ProtocolError WebException : ToString() = System.Net.WebException: The request failed with HTTP status 404: Not Found.  &nb ...Show All

• Visual C# Threading - ActiveX Events/Objects

  Hi, I have a threading problem that drives me absolutely nuts and I don't know what to do: I'm using an ActiveX object and subscribe to one of its events. Whenever I execute the method that drives the event, a couple events are triggered. The event response holds an ActiveX object which I need to work with. What happens now is that whenever the event response returns it runs on a different thread. I want to store the event response activex object in a Hashtable which was created on the main thread. Now, when all the events are done, I continue processing on the main thread. But here's the odd thing: All the actvivex objects in the hashtab ...Show All

• Visual Studio Team System Project alerts exception

  Added a project alert for "A build completes" and added three email addresses. Started a build and got this error in the Event Log: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. Technical Information (for the administrative staff): Date (UTC): 2005-11-10 15:37:48 Machine: TEAMSYSTEM Application Domain: /LM/W3SVC/3/Root/services-1-127760976098191996 Assembly: Microsoft.TeamFoundation.Server, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727 Process Details:   Process Name: w3wp   Process Id: 2 ...Show All

• Visual C# Differnce between DataSourceID and DataSource..

  What's the differnce between DataSourceID and DataSource of the GridView in Web forms Thanks Julia MSDN: DataSource Gets or sets the object from which the data-bound control retrieves its list of data items. (Inherited from BaseDataBoundControl .) DataSource: Gets or sets the object from which the data-bound control retrieves its list of data items. (Inherited from BaseDataBoundControl.) DataSourceID: Gets or sets the ID of the control from which the data-bound control retrieves its list of data items. (Inherited from DataBoundControl.) ...Show All

• Windows Forms It seams I found part of the answer my self :)

  Oh components, I am writing one of them since a week, too much, I know :)  The last think that I was not able to solve is how to make the component discover where he is exactly during initialization, in other words, on what form is bean placed, and in which project. I used a similar code in the components to discover the project in  ...Show All

• Windows Forms Is "simple data binding" in v1.1 one-way by default?

  If I bind a TextBox to an array myList using "simple data binding" textBox.DataBindings.Add( "Text" , myList , "MyProperty" ) ; If I change the string in the text box at run-time, the underlying data in the array is changed (what I expect). If however I change the string in the underlying data (programatically at run-time), the textbox still displays the original value (not what I expect) Is "simple data binding" one-way by default It depends on the data source. Array does not contain a PropertyChanged event, and it does not implement INotifyPropertyChanged; so controls that are dat ...Show All

• Visual Studio Team System TFS Project - Scope of a project

  Each TFS Project can store mutliple .NET Projects. Did the original design of TFS intend on us using only a handful of TFS Projects, each containing many .NET Projects, or was it intended that we would end up with numerous TFS Projects, each with only 1 or 2 .NET Projects included For example, did you intend on the TFS PRoject to be likely named "Team X" containing 50 random .NET projects from the past year, or a TFS Project named "Accounting Project B" that included a single web service, winform application, and web site specific to an accounting problem A response directly from Microsoft would be appreciated. Thanks i ...Show All

• Windows Forms Yet another .addNew question

  I'm doing the typical master-child form. Master's records are in textboxes, one checkbox. Child is in a grid. A relation joins the PK/FK. MasterTable: SRProfile2 Child: SRProfile2Detail PK/FK: Profile2Key Relation: SRProfile2SRProfileDetail I can do the following: Delete a child Add a child to an exising master Edit a child Can not  Add a master + child. Since i can do the 1st 3 items,& ...Show All

• SQL Server Previous and Next functions

  Hi, I am tasked with duplicating many Oracle report in SRS. One uses a stored proc to get a list of people and sorts them by name. It then prints in red those names that are duplicates. It uses this bit of code to do it: If {PlayerName} = Previous ({PlayerName}) or {PlayerName} = Next ({PlayerName}) then Red else Black I don't find any quite so simple functions to do this. I'm at the moment using VS2003 against SQL Server 2005. Thanks, Fairfield We do have a Previous function http://msdn2.microsoft.com/en-us/library/ms156372.aspx Next is not currently supported. An alternative way of d ...Show All

• Visual Studio Tools for Office Visual Studio 2005 Word and Outlook 2003

  Hello! 1.- I use this code for send messages thought Microsoft Outlook, but I want to send this messages with HTML code in the email body. how can I to this this is my code: Private Sub CommandButton1_Click() Dim bStarted As Boolean Dim oOutlookApp As Outlook.Application Dim oItem As Outlook.MailItem On Error Resume Next If Len(ActiveDocument.Path) = 0 Then MsgBox "El Documento debe ser Guardado Primero" Exit Sub End If Set oOutlookApp = GetObject(, "Outlook.Application") If Err <> 0 Then Set oOutlookApp = CreateObject("Outlook.Application") bStarted = True End If Set oItem = oOutlookApp ...Show All

• Visual Studio Team System HELP I THINK I DELETED THE TFS BETA 3 Registration Connection file with TFSREG tool

  Is there a way that I can fix this   Maybe someone can post this registration xml information and I can apply it to this machine.  I am using beta 3.  I just realized that all the registration files are in the TF Setup folder in the Team Foundation Server  folder.  This is just some information in case this happens to someone else. ...Show All

• SQL Server Run report without Login

  Is there any way to run a report via a URL without having the user login Could I provide special parameters on the url or define a user/password in the report itself We do NOT use active directory. Thanks. You can store the credentials needed for the data source access on the report server. Check this BOL link: http://msdn2.microsoft.com/en-us/library/ms160330(SQL.90).aspx Also check the links at the bottom of that page which describe how to manage data source credential settings via Report Manager and Management Studio. -- Robert ...Show All

• SQL Server New to this area

  Hi, I want to develop a application with following features: 1. Develop a windows application in c#. 2. Create different reports using reporting services. 3. Refer reporting services in windows application and show it in Report Viewer. 4. And when ever user creates his own reports, needs be shown in the report viewer by giving browse report option. Can we achive the above all functionalities If yes, please tell me the steps. If client machine is having sql express and in disconnected mode data has to be taken from sql express and in connected mode data has to be taken from sql server. Whether this functionality is also ...Show All