MyerTheFlyer's Q&A profile
SQL Server Logging in SSIS
Logging in SSIS as compared to DTS is more complex to set up with so many events. What events should I choose if I need something similar to DTS package logging i.e. I simply want to see which tasks executed at what time and whether they failed or succeded and if they failed, what was the error Here is a link to the free Reporting Services report pack for SSIS events. I have also found them to be helpful, although the reports could use a little TLC on their appearance. http://www.microsoft.com/downloads/details.aspx familyid=d81722ce-408c-4fb6-a429-2a7ecd62f674&displaylang=en ...Show All
Visual Studio Any tutorial for GAT?
I am wondering if there is any good tutorial available anywhere that would describe how to implement typical guidance scenarios in guidance packages from the beginning to the end Materials that I found so far are not satisfactory for the following reasons: 1. The latest Hand-on Lab seems to be created for the Dec 2005 version of GAT and cannot be registered with Jun 2006 version; 2. Most articles either describe the theory without specific examples or give specific examples of small tasks without describing a big picture; What I am looking for is a specific roadmap from A to Z starting from generating a stub for a guidance package and continuing with specific steps required to implement a scenario until the package is successfully ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Help needed with Spacewar Disaster
Hello, I am a C# begginer and i was just wondering if anyone could help me with a little problem. I have made a basic Spacewar game following a gamestate system. when the game load you press X and the game begins. you are meant to be able to fly a spaceship around but all i can get it to do is turn. i have some code which should fix the problem but i don't know where to insert it. Vector3 modelPosition = Vector3 .Zero; float modelRotation = 0.0f; //Position of the Camera in world space, for our view matrix Vector3 cameraPosition = new Vector3 (0.0f, 50.0f, 5000.0f); //Aspect ratio to use for the projection matrix float aspectRatio = 640.0f / 480.0f; anythough on where the code goes ...Show All
Windows Forms Drag and Drop between my application and windows explorer
Hello Gurus, I have an application developed in C# ,drag and drop option implemented within the appication. In fact, I am able to drag the files from external windows explorer and drop em on my application. Now I want to drag the files from my application and drop em on external windows explorer or desktop and my application should be able to copy them. Could you please give me some suggestions or sample code that does similar thing BTW, I am using Visual Studio.NET 2003 version. Thanks, Sathish Kumar Implement the DragOver event. You can see a code sample in this thread . ...Show All
Visual Studio Team System error 1402 installing virtual server 2005 R2
I have not found a Virtual Server forums.so I write here my question Istalling virtual server 2005 R2 on a Windows XP OS, I'am getting the error "Error 1402 could not open HKEY_LOCAL_MACHINE \Software\Classes\Msxml2.DomDocument.4.0\CLSID Verify that you have sufficient access to that key, or contact your support personnel". My UserId has admin rights so I don't think that access rights are the problem. Logged under the local admin account and tried again. Same error. I tried on un Lap top with windows Xp and all is OK. Why I need help please aurelio I'm going through and setting individual Registry Keys to permissio ...Show All
Windows Forms how to get the event of the mouse scroll
hi, If i rotate the middle mouse button, i need to do scroll operation. here i creating a custom control. i need to add that operation in to that custom control. how to get the event of the mouse scroll operation. I'm not sure what's your concern. Do you have any problem in handling MouseWheel event or something else The following link may help you if you have questions about using MouseWheel event http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemwindowsformscontrolclassmousewheeltopic.asp ...Show All
Windows Forms Launch Conditions - Registry Search problem
I have setup a setup project to install my application and wanted to add a launch condition to test for the existence of a dependent application, I created a file and registry launch condition and the file search works correctly but I can not get registry search to work at all, I would prefer to use registry search as it is more certain than the location of a file which might have another install location other than [ProgramFilesFolder]. The dependent application is Apple iTunes and has a registry key at HKLM\SOFTWARE\Apple Computer, Inc.\iTunes. I have set the Root to vsdrrHKLM. I have tried several variations on the RegKey value and none work: SOFTWARE\Apple Computer, Inc.\iTunes "SOFTWARE\Apple Computer, Inc.\iTunes" SOFTWARE\Apple Comp ...Show All
.NET Development serialport
I create a serialport and i add Datareceived event. When a call is coming i use readline function. I see only RING RING RING... I want to get the caller id. When i use HyperTerminal i write at,then at+vcid=1 and the number is displaed when a call is incomning. Also i receve OK when i write this strings in HyperTerminal. In my program i use the functions write and writeline whith the strings AT, AT+VCID=1 but i dont see any "OK" just the strings i wrote. I dont know if i use properly the "write" function to send strings to the com port or is something else that i do wrong. Can you help me with the caller id You're seeing the modem echo-ing your response (full duplex mode). Make sure ...Show All
Visual Studio 2008 (Pre-release) Retrieve CheckBox Value from Listbox
Hello all I have a ListBox with DataTamplate which contains a checkbox (not binded) and a textblock (binded). I need window ok button click to retrieve each item CheckBox value. How can I do this How can I even retrieve the CheckBox object from an Item ListBox.Items is actually a DataRowView because of the binding and not a ListBoxItem Please only answer to me on how to retrieve the CheckBox value of an Item. Thanx Itzik This technique also works on a ContentTemplate'ed ContentControl: Use ListBox's ItemContainerGenerator.ContainerFromIndex(int) or ItemContainerGenerator.ContainerFromItem(object) to get the ListBoxItem generated with your DataTemplate. Get the ContentPresent ...Show All
SQL Server Public role and guest security concern in SQL 2000 SP4
Hi all, I have setup a new SQL 2000 SP4 and internal auditor query about revoke permission from Public role and remove guest from all databases. 1. Can I revoke all default permissions (select on system tables in all DBs) from "Public" role I am concern any error after such action. 2. I found that guest account in DB -- master, tempdb and msdb. According to Microsoft documents. The account should not remove and can't from master and tempdb. How about msdb Thanks, Regards, Edwin As long as the changes that you make are made using documented features (revoking a permission using REVOKE statement is a documented feature), then you don't have to worry about invalidating your su ...Show All
SQL Server SQL statement troubles finding maximums.
Hello everyone! Here's the deal. I have a table that contains data for contracts each time they are brought to our attention for a review. The first column in the table contains the contract number, the second column contains which review number the data is associated with (the first time it was reviewed, the second time, third, etc.). I need to make a subtable that contains the records from the last review of each contract. The problem is that, of course, each contract can and will have different numbers of reviews than most other contracts. I know how to use the max funtion to return the largest review number of the table, but this doesn't help because not all contracts have that many reviews. Is there any way I can accomplish this us ...Show All
Microsoft ISV Community Center Forums How do I...
select the next row down at the end of my macro. I tried to do this recording a macro using the down arrow and it did not work. Any help is greatly appreciated. Hello Sleeks, The selection.offset(1,0) needs to to have a bigger offset (ie the number of rows that are selected already) use the following lines: nbrRows = Selection.Rows.Count ' store the number of selected rows ActiveCell.Select ' select the first cell of the range Selection.Offset(nbrRows, 0).Select ' come down by that many rows Cheers Chas ...Show All
SQL Server Need ID after OLEDB command (insert)
Hi, I'm stuck on the following thing: After a slowly changing dimension task I replaced the OLE DB Destination task by an OLE DB Command and created the insert manually. This because I need to work further on the dataset. So I do a union all between the output of the two OLE DB Commands (insert and update). Untill here no problem. But than, because I need an ID further on, I do a lookup in the table in which I just inserted and updated my data for the right ID's. When I run this project I get the error message " row yielded no match during lookup ". I don't understand this beacause I just inserted the data and I've checked, it's there. I could resolve this by splitting up in two control flows (reselect all the needed d ...Show All
Visual Studio 2008 (Pre-release) How to move ListBoxItem up and down in ListBox?
Hi, can any one tell that how can move the ListBoxItem up and down in a ListBox.I am able to delete specific item but not able to move them. Hi I want to give this facility to the user, i.e he selects the ListBoxItem and then he presses the move up and down button. If u have any sample code for this please send me.I have done this in .net(ver 2) but i am not able to this in wpf. ...Show All
SQL Server File System Task Error - Process in use
Hi, In the integration services package i'm working on i connect to an excel database and have two data flows which deal with two work sheets in the excel spreadsheet. The data flows do some transformation and then write the data out to a SQL database (two differnet tables). This is all working great however what i want to do once both data flows are complete is to move the directory which contains the current file that is being looped through. At present there is a foreach loop going through a number of directories. I have tried to implement the File System Task object to move the directory but get the following error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file be ...Show All
