milkshake's Q&A profile

• Visual Studio Tools for Office Multi-threading in VSTO

  I have read throught many texts and i am not able to get to a conclusion. I have an excel application. The application queries various tables. After data is obtained through each table it is processes. Doing everything serially takes a lot of time. Is there any way i can put each task on a separate thread. None of the threads will be calling the Excel COM server. The tasks will perform data access/processing operations and once all the threads are done, the MAIN thread will do the writing on the workbook. In other words "Is is possible to do multi threading in VSTO solutions, assuming that threads won't interact with the office object" Thanks1!! A good place to discuss this (and search for pa ...Show All

• SQL Server Migration form MS access reports to Sql server reports

  Does any of the free dowloadable reporting packs come with Reporting Services wizard to migrate data and reports from MS-Access Does SQL Server reporting tools come integrated with any of the VS 2005 tools It may be, but with what is built into Reporting Services you have to have Access 2003. This doesn't mean you couldn't open the Access 97 database with a 2003 version of Access. ...Show All

• SQL Server Using Raw File Destinatin for Raw File Source?

  Hello.... I have a package with a few Data Flow tasks. The first one creates a Raw File Destination and I want to use that raw file as the Raw File Source for some subsequent Data Flow tasks. Is there a way when editing the Raw File Source component in the designer to tell it to use the Raw File Destination that was or will be created in the first Data Flow task When I am designing the package, the Raw File does not get created (at least not until I run it) and I am hoping I can just tell the Raw File Source to use the Raw File Destination and have it pick up the columns, etc from the Raw File Destination. Yes, I can type in the path and file name where the Raw File will be created..but it doesn't exist yet and therefore the Column M ...Show All

• SQL Server control yank in 2005 Query Designer

  How can I assign ctrl+y to remove the line the cursor is on when designing a query in management studio like it was defaulted on in 2000 Muchos gracias. I hate sql 2005 it can suck a duck for all i give a damn please let there be a way to restore my databases back to 2000 how do ctrl+f4 for search this is worse than switching from mssql to oracle on unix why is no backward compatability maintained did apple by these perverts out or something peace out my ninjas you have been a great lot of help may you eternally be blessed with your just rewards ...Show All

• SQL Server DTExec via xp_cmdshell

  In my previous post here: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044739&SiteID=1 Michael Entin provides a number of responses to my questions regarding programatic execution of remote SSIS packages. Having experienced some significant reliability problems with the Microsoft.SqlServer.Dts.Runtime components from an ASP.NET process (the page either times out, or inevitably just stops responding), I have been prototyping the DTExec command option which Michael suggests as being a better approach to remote programability. So, off I've been prototyping this all day today... I have a stored procedure that wraps a call to xp_cmdshell which takes the DTS (DTEXEC) params as a big long argument. This scenario would h ...Show All

• SQL Server update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget   Waldrop wrote: I am guessing that the WHERE clause that you want is something more like: WHERE CaseNumTypeID = 101   AND isnumeric (caseNumber) = 1   AND convert (integer, CaseNumber) BETWEEN 199999 AND 600001 This rewrite will still throw errors and ...Show All

• .NET Development Deserialize - unable to find an Assembly .....

  Hi, I've got a really strange error. I'm using a fairly standard method to implement the IClonable interface, basically I serialize my object to a memory stream and then stream it back again. This all works fine in the .Net runtime environment and if I use a test application. However, I need to run as a COM control inside of an HTML page (long story, but I am embedding it in the home page pane of Outlook). Anyway everything works fine except this routine. It fails when trying to deserialize with "Assembly not found". I added some debug code to load the assembly dynamically and that all works fine. It can't be a version issue as I am serializing and deserializing the same object in the same method. I've traced where the framewor ...Show All

• Software Development for Windows Vista e-book about workflow foundation

  I am trying to learn WF I studied HOL but still have many difficulties in developing a project. Please give me link containing  e-book and other tutorial with many samples.  many thanks   I have a few articles posted on OdeToCode that are "chapter length" articles: http://odetocode.com/Articles/Topic.aspx topic=.NET+3.0 I hope you find them useful. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Space Wars no weapon 4

  When I play The Space Wars starter set, I can play it without problems, till i try to fire the $4,000 weapon. then it gives an error on the modelMesh.Draw(); line You'd need to fix the source model that is displayed for that weapon. An easy hack would be just to copy one of the other weapon graphics over the one that is causing the problem. ...Show All

• SQL Server Report Y-Axis Scale Appears to be incorrect

  Chart Report Y-Axis is not consistently scaling correctly. For many reports, it works well and the Y-axis is correctly scaled. For others, Y-axis scaling is incorrect. We have verified that the data behind the report is correctly reflected in the chart. However, the chart Y-axis scaling is not matching the data. For example in this report excerpt: http://home.comcast.net/~michael.lane/Bad_Y-Scale_Trend_Chart.PNG We are using automatic axis scaling with no programmatic intervention. Most other similar charts from this report display correctly, with correct scaling. Your assistance in pinning this down is very much appreciated. ...Show All

• Visual Studio Team System How do I sync source files with my user docs?

  We use TFS to store our product's design specifications and 100s of other internal documents. Many of these documents are source documents for our product's user manuals, which are also stored in TFS. I am responsible for the user manuals. I need some very simple way of seeing when one of the source documents changes, so that I know when I need to update one of the user manuals. Someone suggested creating a work item that is linked to all the source files. Another person said that reporting was the way to go. Yet someone else said that it would need someone to write a script. Can anyone suggest a simple and effective solution I agree with the person who recommended reporting. Create a code churn report on ...Show All

• SQL Server Server options are not being executed from local programatically code??

  Dear all, For example, executing a DTSX stored in a server, execution is fine and successfully but the log file attached to that DTSX is not created at all after the execution. Otherwise if I'm going to execute from the server everything is fine: log file is created and gathering the usual information. Let me know if exists any option for to enable this from the own DTSX. If I run local packages log files are created without problems. Thanks in advance, Well if the path to the log file is a local path then that will be a path local to where the package executes. This is NOT on the server where it is stored - it is local to the app from which you are executing the package. HTH. -Jamie ...Show All

• Visual C++ /MTd and /clr options are incompatible. Why?

  Ok, here is the long story. I have a nice C++ component which statically links to about 10 libraries as well as links to ATL, C run-time library and MFC. Component is multi-threaded and it actually runs couple of threads inside but everything is nicely wrapped into one DLL which can be called from any .NET program. It was all fine until I tried to migrate this project from VS 2002 to VS 2005. After migration at first I got this message: Building MFC application with /MD (CRT dll version) requires MFC shared dll version. Please #define _AFXDLL or do not use /MD I checked settings and saw that migration changed runtime library option to Multi-threaded DLL instead of just Multi threaded. Well, I have no intention of having 10+ DLLs instead o ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D cameras???

  Hi all, I am trying to create a basic driving game , i have a car model and a model that vaguely resembles an oval track, i have both models rendering and the car moving using the control system in the going beyond xna tutorials, my question is how would i implement a third person camera the looks something like those in Need For Speed Carbon. I would like the camera to follow the car but still be able to have the car rotate within the viewport. If this makes sense, any ideas anyone. Cheers Thanks for ya reply Jon, I dont suppose you know of a tutorial or something that explains these concepts, because im really struggling to get my head around vectors and matrices as well as 3d spave in ge ...Show All

• SQL Server Error reading certain numeric values with VFPOLEDB driver

  It appears that the VFPOLEDB driver tries to convert numeric types in VFP to decimal types in .NET. In this case, it's a Numeric 9,3 in VFP and it's trying to put it into a decimal 8,3 in .NET. I know that VFP has this funny quirk where if you don't use all of the decimal places after the decimal point, it allows you to use extras in front of the decimal point. In our case, the number is 104895.83 and yes, VFP is happy storing this in a Numeric 9,3 column. When trying to read this in .NET, you get this message: System.InvalidOperationException The provider could not determine the decimal value. blah, blah, blah... The question then is - is there a work-around I can find no way to force .NET to use greater precision. About a ...Show All