Humphrey McGee's Q&A profile

• SQL Server XML Result Set expects FOR XML

  I am working on a generally applicable ETL package using SSIS for a large Swedish insurance company. The configuration is driven by XML stored in the database, which means frequently reading XML into variables and doing transformations on those. Although I have it working right now, it is not entirely as I intended. It seems that if I have declared a typed XML column and use the XML Result Set in an Execute SQL Task with the following ...Show All

• Visual Studio Team System .trx insert to DB, Distributed web testing across networks?

  Hi All, I'm trying to accomplish having agents across multiple networks without a VPN.  Right now I'm using windows scheduler to launch the mstests on the agents, and then the agents push the .trx file back to the test controller.  Is there a better way of going about this   From my understanding, all the agents and the test controller have to be on the same network . . . can someone verify that for me If it is the case, i ...Show All

• Windows Forms Repost: Security exceptions calling a web service

  Hi, I actually posted this in the security forum without much response, I thought perhaps this forum might generate a little more help. We're getting a Reflection security exception trying to consume a web service. We're running our application from the  ...Show All

• Visual Studio Local help not available in VS2005 TS RC; please help.

  I am having a (for me) the serious problem that the local help in VS2005 does not display any .NET content. Using VS2005 TS RC1, but the same happend before with VS2005 b2. - only Help on Help and Refactor show up in the index. - dynamic help and F1 help with standard VB code give no results - in Tools, Options, Environment, Help, I have 'try local only' - I cannot use online help, because it's way too slow for me here I suspect that some ...Show All

• SQL Server ExecuteSQL task has changed

  Since the last IDW. The column "ParameterName" has been added to the ParameterMapping tab of the ExecuteSQL task. I enter a statement of SELECT * FROM TABLE WHERE COLUMN = I map to a input variable.  The default name of the parameter supplied is "NewParameterName" My task now fails with Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "SELECT *  FROM  TheBigOne WHERE HostName = " failed with the ...Show All

• Visual Studio Register Manually Installed Visual Studio Express Without Net Access

  I have installed the Express editions of VB VC++ VWebDev VJ# VC# from the iso images available at http://msdn.microsoft.com/vstudio/express/support/install/ on a machine that does not have access to the net. I would like to register these products. I searched the available help and it told me to start the registration at http://register.microsoft.com/regsys/ValueProp.asp FU=http%3A%2F%2Fregister%2Emicrosoft%2Ecom%2Fregsys%2Fregs ...Show All

• Visual C# Aborting and Managing Threads: The Dog or the Cat?

  Newbie here .... thanks in advance for your patience. I'm working w/ C# Visual Studio 2005 I've read up on all the comments about problems w/ aborting and suspending/resuming threads.  Lots of things to consider.  Looks kinda ugly on all fronts.  Note that I'm not thinking of using suspend and resume to synchronize threads.  I would like to just pause and then restart a particular thread from where it left off.  Wo ...Show All

• Windows Forms deployment of a .NET application

  Hi, I'm wandering which strategy to use to deploy an application to my users. The problem is that the application is only partially finished and many new version will have to follow. I know there is something called 'Dynamic update' which automatically pulls& ...Show All

• .NET Development Table With Many Columns: Clicking Column Not Initially Visible To Highlight It And Enter Data (Is Not Easy)

  I have a table with many columns and it is not possible to display all the columns at the same time. The problem I have with this is if I click a right-end column to begin entering data VB highlights the box but scrolls to the left-end of the table. I have to again horizontally scroll to the right-end to see that highlighted box. Thus, I am successful at highlighting the appropriate box and can begin to enter data into that box. But, h ...Show All

• Visual Studio Team System VSTS VPC - http://vstsb2:8080/bisserver/registration.asmx is unaccessible

  Hi, Just downloaded and got the VPC working. When I fired up VS2005, I got the error: "Unable to connect to BIS Service". Did some digging around and found this blog: http://weblogs.asp.net/omarv/archive/2005/04/27/404869.aspx I get the same error after trying the solution documented above. Checked the EventLog and I saw that the TFS was trying to access the following WebService and it was inaccessible: http://localhost:8080/bisserver/Registrat ...Show All

• SQL Server Hundreds Of VIEWS

  What are the downsides to have many multiple views on a SQL Server Database It was somebody's design decision to create 10 views for each vendor in our database- that could range from 20 to 500 vendors ... which means we could potentially have 5000+ views in our database. What is the downside/problems with doing this generally, I would say no, not much downside. Depends on if they are indexed or not. ...Show All

• SQL Server "product level is insufficient" message during flat file import

  I'm using the import wizard to create a new table from a flat file source.  The table gets created but no data gets copied.  What's wrong   Here's the report: Operation stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Error)    &nbs ...Show All

• SQL Server Does anyone know of an easy way (read without going into the XML) of deleting a dataset?

  Please see above In report designer, go to the data tab and in its toolbar click the icon with the red X (deletes the currently selected dataset). -- Robert ...Show All

• Visual C++ /Za compiler option for single file

  Hello, I use VS 2005 Express Beta2 for my native C++ coding. Is it possible to apply compiler options only to certain files I would like to compile with /Za(disable extensions) for my main *.cpp and *.h files and leave standard options for other includes I use vector class and with /Za I get some errors from vector... My code compiles fine. I believe you can specify the exact compiler options for each *.cpp file. Right click on the file n ...Show All

• Visual Studio Express Editions Unable to call a new form by click on toolstrip menu item: compile error: no copy constructor

  hi, i am new to visual studio 2005. i am trying to create "open a new form by click on toolstrip menu item". but unable to do so. i have 'form1 and form2' in my project called as 'TestForm'. by clicking a toolstrip menu item 'menu1' of form1, i want to open 'form2'. i have my code as follows in 'form1'.. #include "Form2.h" ............. ............ #pragma endregion private: System::Void Item2ToolStripMenuIte ...Show All