DanDanne's Q&A profile

• SQL Server run SSIS package with ODBC connection via SQL agent

  It seems there a lot of problems running SSIS packages under the sql agent. I have read the knowledgebase articles regarding permission issues etc but I still can't get my job to run. I can run any package as a job apart from a package that connects to an external database via an odbc connection. Has anyone had any luck with this and can let me in on the secret. I had the same issue: A package using a 32-bit ODBC driver, it ran fine in my laptop but not in my 64-bit server. The work arround was to schedule it through an SQL Agent that used a command line to invoked the 32-bit version of dtsexec. The bottom line: the package runs in a 32-bit mode instead of 64-bit mode Rafael ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. New 2D Xmas Themed Game

  I have written my first ever XNA game, it is a Christmas themed 2D game. It is called Elves Revenge, and screenshots and gameplay demo are available at http://www.errolian.com Full details of the game and the downloads (game, plus source code) are at http://www.errolian.com/2006/11/22/3d-buzz-xmas-game-coding-contest-elves-revenge/   Hello! I have also played the game and for your first time I have to say that it is very good, it need's that little extra as doing the same repetative actions all of the time with out something diffrent happening grates on the gameplay after a while. The music is good, but again a change would be nice, maybe when an elf collects a present&nbs ...Show All

• SQL Server Is there any easy way to evaluate complex date logic in expressions?

  Hello all, I am new to SSIS, so I am hoping there is an easier way to do this... I need to evaluate a date in a field and determine if it is between the beginning and end of whatever the current month is...  In Access, this was written as something like:   IIF ( datevalue  >= CDate ( Format ( Now(),"mm/01/yy" ) )   AND datevalue < CDate ( Format ( DateAdd ( "m",1,Now() ) , "mm/01/yy ) ) , value1 , value2 )   Trying to recreate this in SSIS using expressions during a derived transformation has been extremely difficult.  Here is what I came up with:   ( DUE_DATE >= ( DT_DATE ) ( ( DT_WSTR,2 ) MONTH ( GETDATE() ) +"/01/"+ ( DT_WSTR,2 ) YEAR ( GETDATE() ) ...Show All

• .NET Development System.IO.__Error.WinIOError error

  Hi, I'm working on a process that uses Automation to start Visual Studio and create a solution with a set of Visual C++ projects. I'm getting a strange 'The handle is invalid' exception when I try to print anything out to the Console window (Console.WriteLine()): at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.__ConsoleStream.Write(Byte[] buffer, Int32 offset, Int32 count) at System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder) at System.IO.StreamWriter.Write(Char[] buffer, Int32 index, Int32 count) at System.IO.TextWriter.WriteLine(String value) at System.IO.TextWriter.SyncTextWriter.WriteLine(String value) at System.Console.WriteLine(String value) at APX.TestProgram.TestProgram ...Show All

• Visual Basic "Unable to find manifest signing certificate in the certificate store"

  The story: had this pretty big Visual Basic/Visual Studio project. My old computer crashed, but I had the project backed up. Installed Visual Basic on my new computer and loaded the project. The problem: whenever I try to run it, I get the error message in the subject line: "Unable to find manifest signing certificate in the certificate store" What's this problem, and how can I remedy it I've loaded other (smaller) projects from my old computer and they load just fine, but this one's giving me that error. Please take a look at the following link to get some information about the Microsoft Authenticode Technology: http://msdn2.microsoft.com/en-us/library/ms537364.aspx ...Show All

• Windows Forms Smart Client Install/Uninstall broken

  Howdy all, I have a smart client application that is giving me an error when I try to install it (error text below).  There is an interesting twist though that is likely causing the error.  I recently developed this application in the hopes of making it a smart client.  The server where the smart client application will be hosted does nto have the .NET 2.0 framework installed.  It is not expected to be installed until sometime next year.  In the mean time, it was decided to make a standard windows installer for it. Here's where the problems started.  The solution has a Windows Installer project in it.  The main project is also configured to be published as a smart client.  It seems that during my ...Show All

• Visual C++ Visual Studio 2005 Service Pack 1 Beta

  As part of the continuing effort, Microsoft is announcing that Visual Studio 2005 Service Pack 1 (SP1) Beta will be released the week of September 25, 2006 For more details, please check out the below links: http://connect.microsoft.com/VisualStudio http://connect.microsoft.com/VisualStudio/content/content.aspx ContentID=3311 https://connect.microsoft.com/programdetails.aspx ProgramDetailsID=857&wa=wsignin1.0&wa=wsignin1.0   Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Team System multiple users on some specific work space.

  Hi, There is a way to give more then one owner  (person) permission on some WS-work space Thanks in advance, Shmulik. There was some interesting thread recently, on how to create workspaces that will be "shared" to some extent. Yours truly, Eugene ...Show All

• Visual Studio Team System Refresh add-in MS Project is not picking up dates from tasks in team system and distorting start dates

  URGENT HELP !! I have a project plan where items are scheduled using the leveling tool. All the tasks setup in MS Project were  initially published to team system correctly. On a daily basis, users will update the tasks in team system by entering the actual start date in a customised field called actual start date along with completed and remaining work. Also on a daily basis, I access the project plan and 'refresh' the data so that the actual start date, completed work is updated in the project plan. Upon doing this, I will save the changes and then manually level the project plan so that any newly added tasks are scheduled accordingly and then save. At this stage, I am happy with MS Project's scheduling of tasks and ...Show All

• Visual Basic Starting an application in runtime. Running IE in a new window.

  I am programming in VB.net 2005. I know I can start an IE browser using code that looks like this: System.Diagnostics.Process.Start( www.anywebsite.com ) But the problem is that if there is already an open browser, my VB program will use it and any information that was previously brought up in that browser will be lost (unless the user clicks on the "Back" button of the browser window). I would like to know how to involke a NEW browser each time the user clicks on a button or makes a selection of some kind. Any ideas Thanks, Al W. Dim p As New Process Dim si As New ProcessStartInfo si . FileName = "iexplore.ex ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. YawPitchRoll`

  There is no YawPitchRoll matrix in XNA..... Why yawMatrix=Matrix.CreateRotationZ(yaw); or yawMatrix =Matrix.CreateRotationY(yaw);   Matrix combined = Matrix.Multiply(Matrix.Multiply(yawMatrix, pitchMatrix), rollMatrix); it will be work very slow.....:( may be i can build rotating matrix with precomputed values of sin and cos....   ...Show All

• Windows Forms Printing the_whole_contents of a form.

  Might have posted this is in the wrong forum before, so I’ll give it a new shot in this part which I think is more suitable. Im new here, and there are so many different sections. :) Im using Visual Studio 2003 and is programming a visual basic-application which is based on MDI-parents and -children. The problem I have is that I want to print the whole contents of an mdi children form, but im just getting the visible part. What I need is a method to print even the part that you need to scroll down to see. As it is now, im using this subroutine to generate a bitmap of the form. Private Function GetFormImage() As Bitmap ' Get this form's Graphics object. Dim me_gr As ...Show All

• Visual Studio Tools for Office Outlook add-in in a Citrix enviroment

  I’ve developed an Outlook 2003 add-in using VSTO 2005. The add-in works perfectly on Windows XP and Windows 2003 Now I’ve installed the add-in on a Citrix server. The installation went without any problems and the add-in has been granted full trust. But the add-in won’t load when starting Outlook. The add-in does not show in the COM Add-Ins… or Disabled Items… list in Outlook. Are there any security issues that I should be aware of in a Citrix environment Hi, Can you run the fusion log viewer (fuslogvw) found in the .NET framework SDK on the machine and then try to start Outlook This can shed some more light on why the assembly is not getting loaded. Regards Mohit. ...Show All

• Visual Studio 2008 (Pre-release) Dynamic Style and DataTemplate

  Hello people, may be one of you could help me with this problem. I've a FlowDocument with a picture and a text. I want to consume a webservice that return to me a xaml of a Style (or a DataTemplate if apply); than I want to use that style and apply it to the FlowDocument. For example the webservice return me a style call RightPhoto and I have an object InformArticle with and atribute that say to me that this document has to use the RightPhoto Template/style. Like you see I have to use a dynamic resource form to download the style from the webservice and apply to the FlowDocument. Any idea will be welcome. Thanks a lot !!! For most XXXStyle or XXXTemplate properties in WPF there is a corresponding XXX ...Show All

• Visual Studio Express Editions Database question(again)

  I seem to be flooding the forum with databases but my program is very database oriented and i'm still very new to this. I have a problem. I have a form that contains a datagridview. I have set up that you can only select a row. I also have a button that chooses to update that row. When you click that button, a new form opens up that updates the database in that database in the original form. Unfortunately, when the new form opens up...it goes to the first record in the datagridview, not the selected record on the original form. The update works fine(on the record that is inside the new form) and I'm sure I can add a button that scrolls through the records to the record I want but I would rather the "update" form opens st ...Show All