Scott McKeown's Q&A profile

• SQL Server Equivalent of DTSStepExecStatus in SSIS

  Hi, I am migrating a dts package into SSIS.The dts package has a dynamic property to set the execution status of a data pump task in the package. the dts paskage is setting the DTSstepexecstatus of the datapumptask to 1 or 3 ie waiting and inactive. The dynamic property cannot be migrated to SSIS. May i know any equivalent property in SSIS to DtsStepExecStatus property of Dts. Thanks in advance Neethu There is an ExecutionResult on task, but you can't set it on another task in SSIS. I.e. script task can set its own result, but can't set the result of data flow task. The code you are referring to is common hack in DTS 2000 to create loops. Since SSIS 2005 supports loops na ...Show All

• Windows Live Developer Forums Can you exaggerate the terrain differential in 3D view?

  Just a quick question - i wanted to see if it were possible to (as you can in Google Earth) 'exaggerate' the terrain in VE 3D view. The terrain around the area i am studying is quite flat, but i need to see it in greater relief for the purposes of gravity calculation. Any suggestions/solutions welcome! Have you had a play with this: http://heptazane.spaces.live.com/ Look for the Ghosts sample code. I'm not really into the world 3D models thing but it may give you some ideas John. ...Show All

• Visual C# SELECT-INTO query problem

  Hi I have a SELECT-INTO query which I wish to add some additional columns to the destination table. I can create the table and add the columns after it, but I wonder how is it possible to add that columns directly with the SELECT query. Thanks in advance, farshad Hi, Are you working with SQL Server You can add an additional column like this: SELECT *, null AS AdditionalColumn INTO DestinationTable FROM SourceTable Don't forget to add an alias to your new column, otherwise it will not work. Although this works, the additional column is not always with the correct datatype. When working in SQL Server, it might be easier to create a new table by letting SQL Server generate a script of the source table for y ...Show All

• SQL Server About new SQL Server 2005 Samples and Sample Databases

  There are five msi files listed for downloading. SqlServerSamples.msi AdventureWorksDB.msi AdventureWorksDBCI.msi AdventureWorksBI.msi AdventureWorksBICI.msi What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove Thanks, Hi Jen, Thanks. I are right, the CI means case insensitive. AdventureWorksDB.msi creates a AdventureWork database with collation Latin1_General_CS_AS in your SQL Server. AdventureWorksDBCI.msi creates a AdventureWork database with collation Latin1_General_CI_A ...Show All

• Visual Studio Express Editions Help with retrieving code

  To make a long story short, I made a huge mistake that not only destroyed my main hard drive....It killed my backup hard drive that made me lose the entire code for a program I was working on. It's easily a few months worth of work. I do have the most recent version of the published code. Is there a way that I can retreive the code from that Please help. Thanks. Eric You may want to look into the .NET Reflector and Reflector.FileDisassembler . ...Show All

• Smart Device Development Developing on .net 2005 for bluetooth on wm5

  Hi Where i can find a sample program on VB .net 2005 for communicating with bluetooth on mobile 5 pocket PC Thanks   try the following resources: http://32feet.net/ - provides a managed wrapper, ships some samples http://www.franson.com/bluetools/ - commertial wrapper ...Show All

• .NET Development asserting permissions for called dll

  hello, My dll is calling another dll that does not have the required security permissions to properly run, so I was wondering if it was possible for my code (which is fully trusted) to assert permissions for the dll I want to call and run. Thanks for any help. here's my error: ----- Thrown Exception ----- System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for "System.Windows.Forms.AxHost" threw an exception. ---> System.Security.SecurityException: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0, Culture=neutr ...Show All

• Visual C# Output parameters not working

  Hi All I'm trying to get somme code to work but it just won't and I can't figure it out! I'm trying to get soem information from a database using a uniqueidentifier key field. I want to take the information out of the databse using output parameters. I've created the follwoing code: string ConnectionString = WebConfigurationManager .ConnectionStrings[ "plss" ].ConnectionString; Guid UserGUID = new Guid (userID); SqlConnection conn = new SqlConnection (ConnectionString); SqlCommand cmd = new SqlCommand (); cmd.Connection = conn; cmd.CommandText = "plss_Users_AllUserData" ; cmd.CommandType = CommandType .StoredProcedure; cmd.Parameters.Add( new SqlParameter ( "@M ...Show All

• Visual C# Display 2 different tables in 1 datagridview

  Hello. I have not worked with datagrid earlier and I have to just list two tables in the same datagridview but not at the same time. i want to show "Order" table at load, but when I click on the "customer" button gridview should show customer table. I need help with the code behind the button, how to switch from one order to customer showing in the same datagridview by pressing a button... Please..help hi, yes and because your datagridview is auto generated , it make this trouble, at least the remove the auto generated columns from the collection and set GenerateMember to true, leave it bound to the bindingsource modify mohamed code and to change the dataMembe ...Show All

• Visual C++ Illegal System DLL Relocation?

  When I intend to manually load the user32.dll into memory, after loading the sections and calling its DllMain, an error message appears that the system dll was relocated in memory. If I load it at its preferred ImageBase and thus do not do relocation, this error occurs. However, if I load it into a system choosed address (pass NULL to VirtualAlloc), no error occurs. I can confirm that the loading position of the sections of user32.dll are as correct as the specification tells. Could anyone tell me why Sincerely thanks! No, system restore failed. Had a restore point on 31st March. Doesn't say why it failed, it just states that it couldn't be used. ...Show All

• .NET Development Trying to make Socket object be accessible in many threads

  I'm trying to compile a variant of the Server and Client example programs from the book "Visual C# 2005: How to Program, Second Edition". Basically, (my variant of) the program is a form that allows the user to be either server, or client, of a very simple chat program. I'm practicing the TCP protocol in C# programs, so I'm limiting myself to text network streams. In Server mode, you can (before a connection is attempted): -modify the port -Start listening In Client mode, you can (before a connection is attempted): -modify the port -modify the target IP address -start connection attempt In server mode, while connecting, a new thread is launched and will do these things: -create and construct a TcpListener object, then call its Start() meth ...Show All

• Visual Basic ActiveMovie

  I Found Microsoft Multimedia Control (MCI32.OCX), Microsoft ActiveMovie (AMOVIE.OCX) I use them in VB2005 they are work great but I have some problems like ActiveMovie how to set video's screen to size (32, 24) not to movie original size and how to add PlayCount in Label.text ...Show All

• Visual FoxPro How to manipulate BROWSE NAME objects?

  I am trying to manipulate a browse object. I'm doing a browse nowait and then I make changes to some properties of the object. But then, I can't set focus to the browse window. The following runs through the code all the way to the 'Done'. How can I activate the browse window Thanks. CREATE CURSOR tmprug (rugno c(6) ) INSERT INTO tmprug VALUES ("000001") INSERT INTO tmprug VALUES ("000001") GO top define wind rugs from 06,0 to 18,90 font "Tahoma",10 grow brow fields item=recno():4:w=.F.,rugno NAME oBname wind rugs nowait oBname.AllowAddNew = .T. oBname.column1.setfocus() ACTIVATE WINDOW tmprug WAIT "Done" wind Marcia; I understand that a grid in a form would solve t ...Show All

• Visual Studio Express Editions Problem with RSS reader project

  Hi, I downloaded the beginners videos from http://msdn.microsoft.com/vstudio/express/visualcsharp/learning/#beginners and all was going well, I'm on lesson 15 and have read the additional writing for this project and have done everything shown in the video and I've looked extensively at the snapshot included in the download, my code is identicle and up until now always compiled and executed, after adding the code from this lesson however my application crashes. The problem seems to be here: // Begin the WebRequest to the desired RSS Feed System.Net.WebRequest myRequest = System.Net.WebRequest.Create(rssURL); System.Net.WebResponse myResponse = myRequest.GetResponse(); // Convert the RSS Feed into an XML document ...Show All

• Smart Device Development Access combobox.selectedindex in code

  I am trying to write a sub to set combobox.selected index to 0 I have tried: Dim ctl as Control For each ctl in me.Controls if TypeOf(ctl) is ComboBox then ctl.selectedindex = 0 endif Next I've searched the combobox in help, but cannot find the answer. Any help is appreciated. Thanks Dennis Lackey If I understand you correctly... once you’ve passed your if statement you know the type of the control, you now just want to access it like a ComboBox and not a control so that you can set the SelectedIndex property... if that is the case, you just need to do a little type casting: The long way: Dim cb As ComboBox cb = CType (ctl, ComboBo ...Show All