Mnova79's Q&A profile

• SQL Server Microsoft Participation in this forum

  The VSTS team have posted a really useful manifesto for their participation in MSDN forums which I have read here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=885414&SiteID=1 I'd like to politely suggest that the SSIS team do something similar on here. People have different expectations of what involvement Microsoft do/should have on this forum and it would help if Microsoft could clarify their position on this. -Jamie I find myself half agreeing and half disagreeing. I agree on the basis of having technical background provided and input that is informed from a design perspective and thus enabling performance enhanced responses. On the other hand, original designers may find startling results from experiences ...Show All

• Visual Studio Team System Project and solution source control binding?

  What should the entries look like in the projects and solutions for source control binding with TFS We have seen everything get marked as "SAK" sometimes and other times with a specific GUID and server http address. Which one is right It seems if it is mixed in a solution it gets very confused and starts asking to checkout varying projects and the solution for edit and even if it does, does not update the bindings... Hi: If the project is added to source control along with the solution, then the settings are SAK ("should already know") because the solution has the necessary binding information. If the project is added to source control by itself then the bind ...Show All

• Software Development for Windows Vista Vista Certification Test Cases V1.2 Test Case 18

  Hi, Test Case 18 states "the Upgrade Code in the Upgrade Table must be identical to the Upgrade Code in the Property Table. This means the application properly prepared for upgrade to address the previous package and properly prevent an older package from installing over a new package.” Apart from the wording being slightly off We're not sure why we would need to list the Upgrade code from the property table in the Upgrade table for the same installation. My understanding was that the Upgrade table was for Major upgrades where the product code had changed. Could someone clarify why this is a requirement and what the benefits are Regards Matthew: Maybe I'm missing something but it does not look like you an ...Show All

• SQL Server MDX Question

  I have this Problem with an MDX in Reporting Services, but in the Reporting Services forum, noone can answer it. So I hope, this is the right forum: Consider the following example: SELECT non empty { [Measures].[Amount], [Measures].[Budget Amount] } on columns, non empty { [Products].[Product Hierarchy].[Level4].ALLMEMBERS } on rows FROM [Datawarehouse] WHERE ( [Material].[Material].[All Materials], [Date].[October 2006], [Company].[Company Scenarios].[Scenario].&[Vienna2market] ) I want to select not only [Vienna2Market], also [Salzburg2Market] should be selected, and both as one sum, not 2 separate columns. As I know, the WHERE part needs a Tupel, and each dimension can only be one time in a tupel. The Scenario Dimens ...Show All

• Visual C# Application - Properties: An error occurred trying to load the page.

  Hi All, I was doing a tutorial when i noticed that if I right clicked on my application and selected 'properties,' the properties menu gave me a strange error - 'An error occurred trying to load the page. Exception has been thrown by the target of an invocation.' I have taken a screenshot and placed it at http://members.iinet.net.au/~yimr/error.jpg I tried creating a new document and it still gives me the same error except if I try it in Visual Basic Express the properties page works. Does anybody know what is wrong I reinstalled Visual C# but it did not fix the problem Thx! Diamondplane Most likely something about that project has gotten out of wack, or the solution/project cannot be written t ...Show All

• SQL Server convert getdate() to string dd-mm-yyyy

  I would like to convert getdate() value to string of dd-mm-yyyy format in SSIS... how can I achieve this That works a treat, but it should come with information note that says it will be slower. I wouldn't worry about this for a task, but for a component, I would use the Derived Column over a Script Transform any day of the week, performance is much better. You have the choice however if you feel that the maintenance overhead of the more complicated expression syntax outweighs the performance loss. ...Show All

• Visual Studio Express Editions Open file dialog

  Is open file dialog's purpose purely for selecting file I dont want it to open of the file being selected from the dialog, instead i only want the name of the file selected to be displayed on a particular textbox.How can this be done "Is open file dialog's purpose purely for selecting file " Yes. ...Show All

• Windows Forms DataGridView Refresh issue

  Hi I currently have a dataGridView that is responsible for displaying all of the data from a table within my database. Whenever the table is altered thru another form, the changes doesn't get reflected in the dataGridView until I close and reopen the program. I tried to use the Refresh() method but it seems the compiler does not detect anything new to redraw. I also tried to Invalidate() and redraw the grid, but that doesn't work either. Does anyone have any idea on how to refresh a dataGridView Thanks for your time in advanced. Hi, I found the same problem of refreshing, and this solution worked fine for me. The problem is that when refreshing, after comming back from the child form, the cursor in ...Show All

• SQL Server SP2 issue with execute SQL parametrized query

  Hello, I try SP2 and cannot get the Execute SQL task to work as before. In this example I use an OLEDB Microsoft Oracle provider. The script uses a parameter like that  select Cast( decode(( select DECODE(TRUNC(c.END_DATE), TRUNC(SYSDATE),1,NULL) AS RESULT from one_stage.load_complete c where TRUNC(c.end_date) = TRUNC(sysdate) and c.name = and c.STATUS = 'SUCCEEDED') ,Null,0,1)  as varchar(2)) AS Result from Dual The script task is set to BypassPrepare = False I note only one change, the addition of a parameter setting called Parameter Size set by default to -1 I tried different things like reading the new BOL, changing the Bypass prepare, Changing the Parameter Size and changing the , nothing works. t ...Show All

• Microsoft ISV Community Center Forums Method 'OnAction' of object 'CommandBarButton' Failed

  One of the users is getting the following error message: Runtime Error '2147467259 (80004005)': Method 'OnAction' of object 'CommandBarButton' Failed. The following is the code: Private Sub Workbook_Open() Dim MyCommandBar As CommandBar Dim MyControl As CommandBarButton For Each MyCommandBar In Application.CommandBars If MyCommandBar.Visible = True Then If MyCommandBar.Name = "Worksheet Menu Bar" Then Set MyControl = MyCommandBar.Controls.Add(msoControlButton, , , , True) MyControl.Caption = "GFS BW Printing" MyControl.Style = msoButtonCaption MyControl.Visible = True MyControl.OnAction = "GFS_Printing_Macro" End If ...Show All

• Visual Basic Datagridview selected row problem

  I everyone... I've got a problem at a datagridview row seletion. I've got a function to search  ID in all datagridview rows, and when it find the correct row with my seach id, i need to select the row. At this point, no problem: For Each row As DataGridViewRow In dgvContas.Rows       If row.Cells("CodigoConta").Value = CodigoConta Then         'selecciona a linha correspondente ao codigo de conta         dgvContas.Rows(row.Index).Selected = True         'Altera a area de visualizacao de forma a mostrar         'a linha seleccionada      &n ...Show All

• Visual Studio Express Editions Registration error with Web developer

  Hi, Last week I downloaded and installed the VS Web deleveloper Express Edition 2005. After successful installation I registered the product and got a "thank you" mail from Microsoft. Today I wanted to start working but when I lanched web developer it stated that I need to register the product. I went back to a previous email from Microsoft and clicked the link to a page that displayed my registration key, a 14-digit code, which I entered into the registration dialogue box. But that failed and said that the registration key was invalid. What should I do Best, //Magnus I am having the same problem. I had already registered the Web Developer Express and now it says I have 9 days left an ...Show All

• Visual C++ MSDN Forum Problems

  Last week i had some problems in posting my replies to MSDN forums. Yesterday one of my post were automatically posted and even I could not edit or delete it :( What could be wrong I tried with both Firefox and internet explorer to post my answers. I believe this not the problem at my end. Even if error page displayed. some of my answers were already posted to the forums Is there any problem with Forum Servers The error page had the following error message We apologize, but an unknown error has occured in the forums. This error has been logged. I had a similar issue, but didn't even get an error message. I was unable to post, reply, or edit my posts. The posting page just kept reloading. Tried ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT cannot play wave file

  In the Wave Bank,I select a wave file and click it by mouse right button. It does not play the wave file and appear some error message as below: Connection to the auditioning server has been lost. My wave file is called engine_2.wav comes from the directory of "MySpacewarWin1\Content\Audio\Waves\Ships". The MySpacewarWin1 is the project(SpaceWar windows starter kit) created by the XNA wizard. Did you launch the Audio Console Application ...Show All

• SQL Server Deploy SSIS package to production which has a connection to oracle databse

  Hi There, In SSIS package development environment, I was able to connect to an oracle database and pull data into my sql server database. I installed the client tools for oracle and I put an entry into the tnsnames.ora and I was able to connect. But in production environment, if I deploy the package on sql server, I was wondering if I had to do the same job of downloading the oracle client tools onto my production machine --which creates a tnsnames.ora file to it default location and then edit it with tthe tns entry-- or is there a better way to do this--avoiding the download Can somebody plzz help me Thanks. HiYitzhak, Can you please bare with me I downloaded the windows x86 64 bit install client and this is what I d ...Show All