Spenceee's Q&A profile

• SQL Server Scheduling the SSIS Package to run after every 2 mins

  How can i plan the execution of a package For example, i want to execute the package every 2 minutes for all the time. I do not want to use SQL Server Agent to do this. I want the package to self contained to do it. Thanks Rohit I don't use SQL Agent either, but SSIS packages are not designed to be run like Windows services or Unix daemons. For one, there still is a memory leak in 64 bit (perhaps fixed in the forthcoming SP2) that forced me to write a script to restart the SSIS service whenever the msdtssrvr.exe's process working set size became too large. As for scheduling ,there are probably thousands of ways to do that. One that comes immediately to mind is schtasks.exe, which is a replacement ...Show All

• Software Development for Windows Vista How to access statemachineworkflow instance data directly from Host

  Hi, The statemachineworkflow instance created from the host application doens't reflect the runtime values stored in the workflow instance. new StateMachineWorkflowInstance (AppWorkflowRuntime, instanceId) For example: I have a property named "CurProcessName" in my custom state activity. The value of the "CurProcessName" property was changed in the workflow. When i create an instance of statemachineworkflow, this value is lost in the returned instance. I assume that the statemachineworkflow instance is created based on workflow definition template. Is there any way to create the statemachineworkflow instance from host which will reflect the values stored against the instance Regards, Baskar ...Show All

• SQL Server Problem With the Output of Time Series model

  Hi, I have built a Time Series model to forecast Sales Value. I have used data form Jan 2005 to Sep2006 to train the model. When I write a DMX query to forecast the sales value for next 5 months, it is throwing me the output in the following format. $TIME Sales Value 200610 2874 200611 2875 200612 2874 200613 2874 200614 2874 whereas the output i expected was. $TIME Sales Value 200610 2874 200611 2875 200612 2874 200701 2874 200702 2874 What changes should i make in the model to get the output in the above format. ...Show All

• Microsoft ISV Community Center Forums Can you use VBA to access a spread sheet embedded in a word doc?

  I am trying to use VBA code written in MSWord to access an embedded spread sheet. I can't find any documentation on how this is suppose to work. Does word access the sheet through an instance of excel Is the sheet part of the document so I can find it in the "ThisDocument " I have tried everything I can think of, so any help would be appreciated. Andy - I've just used these: activedocument.InlineShapes(2).OLEFormat.doverb activedocument.Range(1,1).Select The OLE object need not remain activated to keep working on it, so I use DoVerb and the following line right at the top of the code that manipulates the OLE object. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Cust ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XBox 360 hard drive question for MS staff - semi off topic

  With all the great new offerings out or coming soon for the 360: XBox Live Video Marketplace, XNA game creation, and the recently announced IPTV, the poor little 20GB hard drive's days look numbered. Is MS planning to release a larger hard drive for the 360 I'm pretty sure that many people (including myself) would be very interested in one. It's the natural progression of the machine just as the PS2 was later slimlined. The model shown, while seeming to be feature complete, does in fact seem to be a proof of concept rather than a production model. It looks like the larger hard drive and the cooler processor are definitely on the way pretty soon. This is partly because the original 360 suffers from what ...Show All

• SQL Server Populating The Reporting DB - (best practices) (SQL2k5)

  I've populated reporting DB's in the past using different techniques: 1. Have Transactions in Data Tier Write to OLTP AND Reporting DB Simultaneously 2. Log Shipping 3. Restore BAckups Nightly 4. Replication 5. DTS My question is what is the BEST Practice in SQL2k5. I'm all gung ho about using Mirroring but am not certain that this will be the best way to go. My thoughts are something along the lines of this 1. have OLTP Mirrored to what I'll call a "Staging" DB. This is NOT to be used for Failover just as a means of accessing read only data for the Reporting DB 2. Have 2 DBs on another box that are flattened (Denormalized) for reporting (ReportA and ReportB) 3. Use SSIS to Populate the Report DBs ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Spacewar Starter Kit

  Hey , I just started using XNA Game Studio Express . When I load the Spacewar Starter Kit and press start to test the game there is only Xbox 360 functions , Is there any way I can play this using my PC keyboard or send this to my Xbox 360 . Microsoft recently released an adapter so that wireless controllers can be used on a PC. http://www.xbox.com/en-GB/hardware/x/xbox360wirelessgamingreceiver/ ...Show All

• Visual Studio 2008 (Pre-release) How To: Create Custom Client and Service Credentials

  I read this article on MSDN, but it doesn't describe how you consume a custom ClientCredentials on the service side. I'm fairly new to WFC and am looking to create a custom ClientCredentials class that includes additional meta information about the user that can be used to determine what authority they have to perform a particular function within the service. Maybe a custom ClientCredentials class isn't the correct way to do this but I would like to make it as easy as possible for the client side of my services to just instantiate the client proxy and have it use my custom ClientCredentials so that on the service side that meta information will be available to make certain decisions about how to process the request. The article I am ...Show All

• Visual Studio Express Editions js06 nid help (spreadsheet gear)

  hi there... i need ur help in spreadsheet gear.... how can i get the data from the datagridview to spreadsheet gear i have here a sample program that i made but still got an error (nothing happens) dim con as new oledbconnection(constring) dim sqlcom oledbcommand(sqlstatement) dim adapt as new oledbadapter(sqlcom) dim ds as dataset() dim dt as datatable() sqlcom.connection.open() adapt.fill(dt) ' Create a new workbook and worksheet. Dim workbook As SpreadsheetGear.IWorkbook = SpreadsheetGear.Factory.GetWorkbook() Dim worksheet As SpreadsheetGear.IWorksheet = workbook.Worksheets("Sheet1") ' Get the top left cell for the DataTable. Dim range As SpreadsheetGear.IRange = worksheet.Cells(&quo ...Show All

• Visual Basic How to add a label to a TextBox in a ContextMenuStrip?

  I am trying to duplicate the " F ilter for:________________" item in an Access table context-menu. Getting the textbox into the ContextMenuStrip was easy, but how do I add the "Filter for:" label TIA ginnyK Hi, You need to create a user control with a label and a textbox to do this. Once you have the control embed it in a ToolStripControlHost. Here's an example with a DateTimePicker to give you an idea: ToolStripControlHost dateTimePickerHost ; private void InitializeDateTimePickerHost () { // Create a new ToolStripControlHost, passing in a control. dateTimePickerHost = new ToolStripControlHost ( new DateTimePicker () ); // Set the ...Show All

• Community Chat Gre Need some feedback or advice for my web site

  Hi I am in the progress of developing a web site whereby developers can do free online tests on various programming languages. I would just like some advice or feedback on ways to improve the site or other comments of the site The site is http://www.quiznetonline.com Thanks in advance Mark OH Gee.. I flunked most... Dang... Anyway I gave up after a few questions.. Everything I went to seemed to work as I would expect.. You have the Red and Green circles with check marks inside.. Yes I know the answer was up at the top but for me I would like to see a Arrow or something to the Left pointing to the circles (well at least the ones I passed!) ...Show All

• SQL Server database backup job quits for no apparent reason

  I created a maintenance plan to back up a database as a file to another server. Full backup was specified. The job has been running for about 3 months, then quit last night (after the server was rebooted). Error is: Message Executed as user: xxxxx\Administrator. The command line parameters are invalid. The step failed. not sure what to do to fix this - - This is typically caused by the account changing the password. If you change the password of the account you used to run the job, you won't see any problems until you reboot your server/restart SQL Server service as this is the only time that the new security credentials will take effect. ...Show All

• Visual Studio Express Editions Application running both as Console and Windows Forms

  Hi, I'm creating my own compression utility in VB 2005. So, I'd like the user to be able to run my app from the command line (giving arguments to the executable) but also as a normal Windows Forms app (even checking if no arguments are passed in the command line, if the executable is launched in the console). I tried to create a Windows Forms project and then set the output as Console, but this way the Console window stays opened (and I don't want). I also tried to compile as Windows Forms (as it normally should) putting in a module a Sub Main, but this gets ignored since the startup object is necessarily the main form (and from Project Properties, the IDE doesn't let me change startup object to Sub Main). Should I try to c ...Show All

• Windows Forms Why does the ClickOnce 'Install' button generate an xml page instead of starting download?

  Hello, I just published my application for ClickOnce deployment to my web site. When I click on the Install button on the publish\publish.htm page on my website, the browser returns the contents of an xml file and does not start the download. Does anyone know what might be causing this Any help or suggestions would be greatly appreciated. Thanks! Jason I have the same problem with ClickOnce application and IE6, the browser recognize it as XML text file, the funny thing is that it works fine on FireFox with appropriate extension. Any way I have digged the web after the solution but still unsuccessfully. There is an article about MIME sniffing control, I have followed that instruction but unsuccessf ...Show All

• .NET Development Convert image to pure Black and white

  I want to convert a tif or jpg file into pure black and white after searching in internet, I find a way to convert a picture to gray scale http://www.bobpowell.net/grayscale.htm but could I modified it to convert to black and white I have no idea about anyone could me THX If you mean only the colours black and white, you can use the same code as the guy does in the article, but instead of: Color.FromArgb(luma, luma, luma) Just have something like: luma > 0.5 Colors.White : Colors.Black i.e. if the luminance is greater than 0.5 make it white, else make it black. ...Show All