Duncan Woods's Q&A profile

• SQL Server Errors / warnings after deleting variables & Connection Manager objects

  Hi, As I was developing my SSIS package, I created several variables and tasks ( FTP, WMI Reader Task ). I am now cleaning up, deleting unwanted variables and connections in the design window. I save and build the package and when I load the package, I get warnings that these variables are referenced but can't find them and errors that the WMI connection is not found. When a package calls a sub-package, it stores the absolute path of the child package in its dtsx xml file in a Connection String property. How annoying !!! . When I deploy this to another machine with a different file structure, it becomes a problem. Why can't it store the path relative to the parent package, which would be typically in a sub-directory under the paren ...Show All

• Visual Basic How can I password protect my source code?

  Hello all. I am using the Visual Basic 2005 Express Edition. I would like to enquire whether it is possible to password protect my source code such that it requires a password to open each time I want to view it (Just like password protecting documents and spreadsheets in Word and Excel.) I can't find the option under the Options menu. Thanks in advance. Hi,  In that case then would it be possible to create an application that could feed it's output to the Visual Studio I.D.E. such that it streams an encrypted file to the Visual Studio i.d.e. when that file is opened This application could be called something like A.D.E.P.T. Application-Decrypter-Encrypterfor-Projects-Tool ADEPT become ...Show All

• SQL Server How to restore SQL 2005 DB to SQL 2000

  Hello, I'm tring to restor a DB from sql 2005 (which is located on my local computer) into sql 2000 (which is located  on the server) and I am getting this type of message: TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=08.00.0818&EvtSrc=MSSQLServer&EvtID=3205&LinkId= ...Show All

• Visual Studio Sandcastle - can I exclude items from docs via attributes?

  I have some code in my library which I want to exclude from the documentation but I cannot mark as internal, private, or otherwise. I have created a custom attribute called "Unsupported" and placed that attribute on certain interfaces, properties, and methods. Ideally, I would like Sandcastle to ignore items marked wtih this attribute. Is there a simple way to accomplish this Perhaps something in one of the transform files Thanks for any help! Ken In the current CTP, there isn't a way to exclude public items. Support for the <exclude/> XML comment tag is in the works for Sandcastle though. Eric ...Show All

• SQL Server HELP--SSIS Dataflow Task

  Need help regarding ssis dataflow task I need to create a ssis package. I want to import the data from a flat file to a table. Lets say, the table has 5 columns -- col1, col2, col3, col4 , col5.(Assume that all columns can be NULLABLE) The datafile contains the data related to only three columns say col1, col2, col3. So when I use dataflow task to import the data from the file to the table, I will only get three columns, col1, col2, col3. Columns col4, col5 will be NULL. However, I want to populate columns col4, col5 with some values which are stored in the variable. IS there any way to do this Any help would be appreciated. Thanks Nullable flat file columns is a bit of a strange one, how ...Show All

• Visual C++ How to change the File Extension.

  Hi all, i want to change the file extension. how can i do this in vc++6.0. for example. i'm having example.xml after doing some manipulation on that file and i want to change the file to example.ini is it possible how can i do this Regards and Thanks -Amjath You could also take a look at FSO. FSO is discussed on http://msdn.microsoft.com/msdnmag/issues/06/09/CAtWork/default.aspx very briefly. Hope that helps. ...Show All

• .NET Development Recieving error when using XmlSerializer

  Below is the code I am using. ** My Item.CS class that contains the methods and variables used by most of the items. public class Item { private int mItemCost = 0; private int mItemResell = 0; public int ItemCost { get { return mItemCost; } set { mItemCost = value ; } } public int ItemResellValue { get { return mItemResell; } set { mItemResell = value ; } } public void Save( string filePath) { if (!filePath.EndsWith( "\\" )) filePath += "\\" ; System.IO. Stream stream = File .Create(filePath + ItemFilename); XmlSerializer serializer = new XmlSerializer ( typeof ( It ...Show All

• Visual Basic How do I make a textbox that automatically updates when someone types something?

  I'm writing a program, and I need it so that whenever someone types one number into the textbox, a variable automatically updates and compares itself to another number without having to press a button or something. Can someone explain how to do this, please Thanks. Use an event on the textbox - perhaps textchanged event rather than a button click event. This way when the text on the texbox changes the code will execute. ...Show All

• Smart Device Development Anyone know what the prototype pinvoke for checking disk space looks like?

  Thanks! http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_frm/thread/8d84c5b664161cb6/f7e1fcfe668f0422 q=GetDiskFreeSpaceEx&rnum=3#f7e1fcfe668f0422 ...Show All

• Visual Studio VSHost.Exe and .Exe.Config in Release Builds???

  Strangely enough VSHost gets copied also into release configurations. This seems very odd. You have to disable it on a per-project basis (a bit of a pain if you're trying to get quick builds out the door). Is there a reason I'm overlooking why it would get copied to a Release build We support debugging both debug and release builds. The hosting process speeds up debugging of any given project, not matter it's build flavour. Remember, you can add other flavours with different build options and decide on a case by case basis whether you want to enable vshost on each of them John ...Show All

• Windows Forms Dock property bug?

  Hello All. I'm wondering if anyone else has run into this rather bizarre behavior. I've got this form that every time I open it in the editor it shows up with the asterisk in the caption, like the dirty bit is set and there are unsaved changes. When I close it, I'm prompted to save the changes. Every time. It doesn't matter if I open it in graphic design mode or code editor. Well, my WTF bug went crazy and I traced it to a Text Label control. If I set the Dock property on this control, the dirty bit presents every single time the form is opened. If I reset the property to "None", all is well. I can duplicate this behavior on any new form with a "Docked" Text Label control. The Anchor property has no effect o ...Show All

• Software Development for Windows Vista How to render 2 video streams using EVR?

  By now my app can just play 1 stream using EVR. The usage is similar with using Windowless VMR9 filter. I have read "Writing Custom Mixers and Presenters" on Vista Platform SDK Doc many times and search the relative topics using google. But I can't find out much information, specially about how to render 2 streams. Who knows how to write a custom mixer, which interfaces should be called and their steps. Or tell me where has some materials on this knowledge Thanks Microsoft Guys!! As soon as I'll have some time, I'll try to update the MultiVRM9 sample to make a MultiEVR. But before, it's time for questions: Regarding the CLSID_MFVideoMixer9, where can we find interface description and how to use it Do you ...Show All

• Visual Studio Team System Exception thrown when executing unit test

  I have VS2005 Team Edition. In my test, I am creating an instance of a class that I intend to test. When I execute, the 'new' statement throws an exception: Test method UnitTest2.UnitTest1.TestMethod2 threw exception: System.TypeInitializationException: The type initializer for '<Module>' threw an exception. ---> <CrtImplementationDetails>.ModuleLoadExceptionHandlerException: A nested exception occurred after the primary exception that caused the C++ module to fail to load. ---> System.Runtime.Serialization.SerializationException: Serialization error.. The assembly containing the class does have a reference to a C++/CLR (interop) project. When I modify the experiment to instantiate a class in the interop project, I ...Show All

• Visual Studio 2008 (Pre-release) Application scoped variables in WCF, how do I get to them?

  If I set a variable in global.asax and store it in Application scope, how can I reference that variable in a WCF service If I cannot do that, is there another way to accomplish the same result I'm hoping to store an instance of WorkflowRuntime in an application scoped variable and retrieve it in various services in WCF. Good idea TheJet. I employed that approach along with a conversion of this code to WCF from ASMX. That code sample was a result of this awesome thread on the topic of how to host a workflow runtime. ...Show All

• Visual Studio Express Editions Different Coloured Brushes

  How do I change the brush colour so that each square is different I was thinking of using an array, Dim arrCol() As String = {"Red", "Yellow", "Green"} but string can't be converted to system.brush. I tried Dim arrCol as System.Brushes, but that doesn't work either. So any ideas please. Here's the code, Dim B1 As New Bitmap(146, 92) Dim G1 As Graphics = Graphics.FromImage(B1) Dim PB As New PictureBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim X, Y, W, i As Integer X = 0 Y = 0 W = 128 For i = 1 To 40 G1.FillRectangle(Brushes.Blue, X, Y, 16, 16) X += 18 If X > W Then X = 0 ...Show All