R. Green - MSFT's Q&A profile

• SQL Server I hate this

  I'm migrating a fu... dts to SSIS. That's fine. I've got a derived column task for stuff as cdbl(DTSSource("Col014") /100). But how the source plain file have a lot of columns suddenly I find this: Function Main() Fecha=Right(DTSSource("Col014"),2) & "-" & Mid(DTSSource("Col014"),5,2) & "-" & left(DTSSource("Col014"),4) If IsDate(Fecha) then DTSDestination("FechaOp") =Fecha Else DTSDestination("FechaOp")=null End IF Main = DTSTransformStat_OK End Function So that 'Derived Column' is useless at all for to encompass this rule unless t ...Show All

• SQL Server SQL Server 2005 on Itanium?

  I am attempting to upgrade our SQL 2000 server to 2005 on an Itanium2.  I have downloaded the IA64 disk from MSDN, however to install it asks for the Windows Installer 3.1 Redistributable (which is only available to x64).  I am running Windows 2003 Enterprise Edition (IA64) Service Pack 1, v.1069.  Thanks for pointing me to the update.  I installed it, but I am still getting the same sorts of errors.  misexec tells me I am still running version 2.00.  I am positive I have installed SP1 and the update.  Should I attempt to reinstall SP1 again -Jack  ...Show All

• SQL Server Index on bit fields in SQL Server Management Studio

  I noticed that I can put a bit field in an index in a SQL Server 2000 database, while using the SQL Server Management Studio (shipped with SQL Server 2005). In SQL Enterprise Manager this wasn't possible. Does SQL Server 2000 support indexes on bit fields and doesn't Enterprise Manager support it, or doesn't SQL Server 2000 support indexes on bit fields and is it a 'bug' of the SQL Server Management Studio Thanks. Well you actually can create indexes on bit fields in SQL Server 2000, but you can't do it through the Design Table Interface. You could either use T-SQL to do it or if you want to do it Visually ...Show All

• SQL Server How to browse a cube using a web browser

  Hi, I would like to know how to browse a cube using a web browser. So far, my company is using excel to browse the processed cubes but they want to extend the access to other departements and therefore accessing and browsing cubes using a web browser would be more appropriate. I thought using Reporting Services. Unfortunately I don't know the steps to follow. Thanks. Yes, you can use Reporting Services. I would start by checking out the basic Reporting Services Tutorials in Books On-Line. Then to create a report against Analysis Services, when creating a Data Source change the type to an Analysis Services and proceed from ther ...Show All

• Software Development for Windows Vista Beta 2.2

  Hi guys, I've installed Beta 2.2 tried to port an ASP.NET application, that uses StateMachine Workflows. However it seems that some key classes like WorkflowWebRequestContext and WorkflowTransactionService are missing and some new one like WorkflowCommitWorkBatchService are added in the new Framwork. The absence of WorkflowWebRequestContext I managed to replace by using a static member to utilize a single instance of WorkflowRuntime. However the DefaultWorkflowTransactionService is missing and that I thik causes problems executing my StateMachine Workflows. Due to the changes made in Beta 2.2 currently the Samples are not working a ...Show All

• Windows Forms ImageList does not load because of missing resource

  I have a WinForms application (under development), the application's main form has an image list on it. There are several images in the list. The application used to run fine till one moment when it started throwing an exception at startup: An unhandled exception of type 'System.Resources.MissingManifestResourceException' occurred in mscorlib.dll Additional information: Could not find a ...Show All

• Visual Studio Express Editions Help: ActiveX on the fly installation

  How do I install an ActiveX control on the fly in VBExpress, like MSAgent core and the text to speech engine If the required X controls are missing trigger a d/l. How long will COM ActiveX controls be supported along with MSAgent Generally activex controls are installed/registered the same way you register any type of COM object.  ex. run regsvr32.exe on the control.  VS setup projects also support registering controls if you are building an MSI.   Embedding the control in an html object tag is how you would do it for web deployed activex controls.  For msagent info, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. No shader syntax highlighting

  The readme file of the Dxsdk December update says: "HLSL syntax highlighting works properly in Visual Studio 2005 but the Direct3D 9 Shader Debugger is not currently supported. " Well, the syntax highlighting has never worked for me in VC++ 2005. I thought the Dxsdk December update would fix this ( I found another post here that said it would) but it didn't. Is there anything I can do to activate it   Kloda wrote: The readme file of the Dxsdk December update says: "HLSL syntax highlighting works properly in Visual Studio 2005 but the Direct3D 9 Shader Debugger is not currently supported. " Well, ...Show All

• Smart Device Development error C3861: 'wcsftime': identifier not found

  I am converting a project from EC4 to VS 2005 and I am gettign this error right off the bat. The actual line : C:\Program Files\Microsoft Visual Studio 8\VC\ce\atlmfc\include\atltime.h(402) : error C3861: 'wcsftime': identifier not found This is coming up right on the StdAfx.cpp file which looks like this: #include "stdafx.h" #ifndef UNDER_CE #ifdef _ATL_STATIC_REGISTRY #include <statreg.h> #include <statreg.cpp> #endif #include <atlimpl.cpp> #endif     Stdafx.h looks like this: #if ! defined (AFX_STDAFX_H__4590750F_B1AD_470C_B322_498034EEED18__INCLUDED_) #define AFX_STDAFX_H__4590750F_ ...Show All

• SQL Server SQL 2005 Sept. CTP: Installation error related with encryption

  Hi everyone, I've been trying to get SQL Server 2005 Sept. CTP installed for a few days and always end up with the same installation error:  "Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. " The installation is on a Windows 2003 SP1 machine with an SQL 2000 already installed under a non-default instance name. I have no idea as to why this is happening, and would really like to hear from others who might have had this problem. Thanks. Alex ...Show All

• Visual Studio Team System Setting Build Status

  I am writing a script that does NOT extend the Microsoft.TeamFoundation.Build.targets file. Everything has gone well but I cannot get the logger in VSTS to report success. The build has definitely succeeded and the text log file says that it has too. I have tried calling the UpdateBuildFlag method on the BuildStore but with no success. I wondered whether it was because the "Initializing Build" step was still set to "In Progress" but it does not appear to be possible to update that value from the Build Store interface either. Any ideas Thanks, Si... The Buildstatus value depends ...Show All

• Windows Forms How do I trigger SettingChanging from custom property of ApplicationSettingsBase?

  Hi, I have a MySettings class that inherits from ApplicationSettingsBase. One of my properties of MySettings class is a custom C# class with a set of properties. I do this to group the properties, but want the MySettings class to contain all kinds of settings, so that only 1 class is needed for saving the settings. But how can I be sure that when a property of my custom class triggers the "SettingChanging" event up to the MySettings class Does the custom class have to inhertit from ApplicationSettingsBase as well Or is there another way I should do this Thanks! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Video in DirectX

  Hi again =) So I made myself an "intro" movie... now.. how do I use it in directx c++ A little more information might be useful Are you just wanting to play the movie as part of a regular windows application, or as part of a Direct3D-based application Any particular version of DirectX, or just the latest-and-greatest DirectShow will be the component that's most likely to interest you - although it was recently moved to the Platform SDK ( so you won't find it in the DirectX SDK download ). The "Playback" section from the  list of samples on the above contents page is likely to be of particular interest to you. hth Jack ...Show All

• .NET Development BindingList<T>.RemoveAt and Dispose

  I have a collection inheriting from BindingList<T> which contains objects that implement IDisposable. If I remove an item from the list, does the runtime automatically call Dispose() on the removed item, and if not, how should I go about calling Dispose Looks like I'll have the same problem with ClearItems(). The individual objects follow the pattern for IDisposable as listed below... #region IDisposable private bool _isDisposed; public void Dispose() { Dispose(true); GC.SuppressFinalize(this); } ~MyObject() { Dispose(false); } protected virtual void Dispose(bool disposing) { if (!_isDisposed) { if (dispo ...Show All

• Visual C# Getting date without the time

  Hi I would to be able get the date but not the time. I currently use gerdate() but it returns for example 09/09/2006 16.34.56 but all I owuld like is just 09/09/2006 can this be done I have tired looking on msdn but I could find nothing that I could use. Any help would be a great help Of course. Use the DateTime class. I believe the method you're after is DateTime.ToShortDateString(), but I could be mistaken. DateTime date = DateTime.Now; Console.WriteLine(date.ToShortDateString(); Otherwise you could always use the different components and put them together to your liking. DateTime.Year, Da ...Show All