andymac7's Q&A profile

• SQL Server SSIS and the Receive Command

  I built a system where I am sending batches of messages using a single conversation. I want to pull these messages out of my queue using Service Broker. I may have more than one batch sitting in the queue waiting to be picked up, so.... In my SSIS package i started by getting a unique list of conversation_handles where the message type is my end of batch message ( should only be one per batch). Then I used the foreach loop construct thinking I could pass the conversation_handles around and into the data flow. In the data flow I want to pull all of the messages at once. It looks like the receive statement is designed to do this with the concept of using a table variable. So I built this SQL to use in for the SQL Command of my OLE ...Show All

• SQL Server Time Dimension and Plan Table

  I'm new to this and have implemented a cube with a Office table directly lated to a fact table and time dimension. My fact table contains many dollar about to calculate against the plan for the year. I have a Office Plan table related to the office table which has the "plan" dollars for the year. But my Office Plan table has only a Plan Year not a date column so my plan amounts are totaled and can't be sliced. So I really can get the plan by year to do calculate the statistics against my fact table. My Office Plan table is a fact table as well. I hope this makes sense. What is the best way to implement something like this should I generate my office plan by day/date not year Yes, Model your data to the lowest ...Show All

• Visual Basic VB 2003 & .Net 1.1 - Data Write/Read Issue

  Hi, Working upon an embedded application and have conclusively found the following issue. I have an application that was written before in VB6 that has been upgraded successfully to VB.Net 2003. All issues resolved except the following. Previously, we used the Win32 API to make data writes to a logical disk upon the PC. With the current code, we have upgraded to use the FileStream .Net approach to make all data writes and reads. For interest sake, this is an embedded application that keeps some data in a specific logical drive. The issue is as follows, when I power off the PC and power on, the data is being trashed upon the logical drive where it is being written. I am almost certain that the VB.Net approach we have imple ...Show All

• .NET Development Changes made to multiple tables

  Hello all, This may sound rather silly (a newbie question...), but is there a way to have more than one table in a dataset, and to have the dataAdapter updated afterwards with changes that were made to all tables If not (as I believe would be the case), what is the easiest way to go about this Am I obliged to create a dataAdapter & dataset for each table if I wish to minimize the usage of dataAdapter.update dataAdapter.fill methods (initializing/filling the Dset & Dadapter upon Form load, then having a certain point to update, instead of updating with every click event and the likes..) Hope this was coherent enough , thanks for any answer.. Hey, thanks for taking the time... My problem, to be more precise, was when I've trie ...Show All

• Visual Studio Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  I've been running a project that I'm developing in C# for some time without the following error. Now all of a sudden it appears and I'm not sure how to get past it. I've altered my debug setting from the browser but I still get the following errors. Any suggestions thanks, 'WebDev.WebServer.EXE' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'WebDev.WebServer.EXE' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\WebDev.WebServer.EXE', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'WebDev.WebServer.EXE' (Managed): Loaded ...Show All

• .NET Development Stopping/Killing a windows service

  I'm writting a watchdog application that will test a windows service on the same server. If the service does not respond with updated information I want to stop and start the service(this seems to take care of our problem); however, the service does not always stop in a decent manner and it seems that I need to kill the process. I have tried to implement process.kill(), but that doesn't seem to be doing the trick either. Is there another way in c# to kill/terminate this process SurreDeth: See attached code. It uses WMI to stop/terminate a Windows Service. I used this code to restart hung services across a cluster. You can also run this code against remote targets (assuming that the user executing the code ...Show All

• Visual Studio Express Editions MessageBox Centering

  Is there a way in VisualBasic 2005 to bring up a message box centered related to my application, rather than centered relative to the entire screen I'm using 1280 x 1024 screen and my application (with a fixed size) doesn't cover the entire screen. Most of the times, my application window is closer to one of the edges of the screen and its message boxes pop up away from my application, in the middle of the screen. Thanks in advance for any tips. You could just use a new forum put ontop of your first one and make it cisible when they click a button, then not visible or hide when they click and "Ok" button. Hope this helps - ItsMe!!! ...Show All

• SQL Server Create a calculated member on one measure.

  I have a Version dimension which is used to break out the Net measure by 'Actual' or 'Budget'. Net is the only measure I'm using. By not using the Version dimsion. The net is incorrectly totaled by both values. Both are not used together. 'Actual' and 'Budget' are the only two members of the Version dimension. I want to add a third member which subtracts 'Budget' Net measure from the 'Actual' Net measure and call it variance. A caculated measure isn't working for me because obviously subtracting Actual - Budget doesn't work so well. Can anyone help me with that OK I got it to the point where there are no errors, but the Variance member will still not show up in the Version dimension. WHat could be the cause /* The CALCUL ...Show All

• SQL Server SQL2005 SSIS - won't allow text delimiters

  W2k3 server, SQL 2005. @@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I'm trying to set up my first SSIS package to import a flat file to a database table. The connection manager will not allow a text qualifier. My data is comma delimited, with doublequotes around each field. If I enter " as the text qualifier, then I get the error "The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at run time." The data in Columns view shows as just one column rather than multiple columns. If I leave the text ...Show All

• SQL Server SQL 2005 Server Agent won't start

  When I attempt to start the Server Agent Service, it tells me it started, but stopped immediately. When I check the log files for the agent, I get the following two entries: 2007-01-03 15:07:11 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2007-01-03 15:07:13 - [098] SQLServerAgent terminated (normally) This same error was posted inanother forum and I was directed here. The EventLog is running (I did an SC command) so I am lost. Help Did you check if the event log is full HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Team System Version Control: How to Compare Directory vs Project?

  Hi everybody, How can I compare the contents of my workspace against a project in Source Control The command line tf diff myProjectDir /recursive /noprompt just outputs the pending changes source control already knows about, which is just what tf status provides. The Source Control Explorer in Visual Studio doesn't compare directories at all - even so it is described in the help files. But I want to know Which files are in my local directory but not in source control. Which files are in source control but not in my local directory. Which files are in both places but differ in content. To put it short: I am missing the Visual SourceSafe "File/Project Differences" and the acompanying ...Show All

• SQL Server SSIS and low values

  I have run into a situation executing SSIS packages when the Source is a mainframe database using an ODBC driver. It appears that SSIS just stops running when it hits a row with low-values and does not always give a meaningful message. Is this true that SSIS package will just stop processing rows of data if it hits low-values MaryOS wrote: I get the same problem using the driver with Access Exactly. So the problem is in the ODBC Provider. So if I were you I would contact the vendor of that driver and ask them to help out. Good luck. -Jamie ...Show All

• Visual C++ How to copy a specific contents of a char array to a string variable

  Dear folk, using win32 C++, I am looking for a function that can copy a specific number of charactes (starting from a specific index), of an char array to a string variable. a code snippet as follows: { char charArray[255]; string stringVariable; //copy a substring from charArray[12] to charArray[25] into string. } I wonder if there is such a string function that can help me to achieve my requirment. Regards Bassam Marius Bancila wrote: There are many ways: Yes, there are many ways; another possibility is: stringVariable = std::string(charArray+12, 14); ...Show All

• Visual Studio Double Buffering help needed

  I am trying to reduce flicker in my application by using double-buffering. Unfortunately, the result is not what I was hoping to get. Is there any way to view the content of the memory DC while drawing different components on it Thank you. Sam Hi Sam. I have a tool that views most GDI objects (including memory HDC) in a Visual Studio Debugger's toolwindows. Almost like you view other data types. Check it out: www.FeinSoftware.com/FeinViewer.php Vlad ...Show All

• Visual C++ using visual C++ as C programming IDE?

  Hi all: I am wondering can I use Visual C++ for C program IDE. It seems to me that Visual C++ does recognize C program, but when I am going to create a project for C using Visual C++, it has no option for a new C project. Also, if it can, is it a good idea to using it as a C programming IDE Thanks!! While the IDE does not have an option to create a C project you can use any C++ project and then add *.c files to it. The IDE knows the difference between *.c and *.cpp (and *.cxx and *.cc) files and will invoke the C compiler instead of the C++ compiler. ...Show All