santhosh_cz's Q&A profile

• SQL Server Date formats in SSIS

  Hi once again guys, I seem to be struggling with everything in SSIS these days! I have a datetime field and I want to convert it to the following format in my derived column component : yyyy.mm.dd I also have another datetime field but this time I am only interested in the time values and I want to get : HH:MM How do I go about doing this in the SSIS expression builder Please help. You have to surround your conditional statements with parenthesis and then concatenate them with the "+" symbol: (LEN((dt_str,2,1252)DATEPART("mi",btg_opty_start_datetime)) == 1 "0" + (dt_str,2,1252)DATEPART("mi",btg_opty_start_datetime) : (dt_str,2,1252)DATEPART("mi", ...Show All

• SharePoint Products and Technologies Error message in designer 2007 - Failed to load workflow

  Hi all, I was trying to create a custom workflow through the designer 2007. While I clicked on a new workflow button, I got the above error message. I have checked that all the necessary components are installed like windows workflow foundation 3 on the client machine. Can you please help me know what is the cause of this problem and also the related solution I would appreciate your early response on this. Thanks, Kedar 1. What does your sharepoint log tell you Check program files\common files\microsoft shared\web server extension\12\logs 2. Do you have any dependancys that arn't in the GAC 3. Do you have a field or property that cant serialize Regards, Daniel ...Show All

• Visual Studio Express Editions stupid questoin about bitmaps

  I have just begun to use Visual basic recently, and I want to create a picture. I don't want to use picture boxes(they start to lag after alot of them have been placed on the form) I know that you can use bitmaps, but all the different methods I have tried to use have ended with a blue squigly line under part of the code. I would like the code to load one of theese bitmaps, via... Public(or private, whichever works)sub form1_load <insert whatever code is needed> End sub if possible. Thank you very much in advance! You explained that you wanted a game -like style, may I suggest using the AxShockwaveControl which I'd be more than happy to design flash animations for you. The drag ...Show All

• Visual Studio Team System Unit tests not running in build type

  I created a build type that includes a test project and has a configured test list. When I run the build through Team Explorer, the log file reports: : warning : Test <testname> can not be found. It lists the four tests I have in my test list, so it can see the list, but can't find the tests. What am I doing wrong TIA jdn Hello, I'm guessing that your tests are not inside the test lists anymore. This could happen if you moved the project, or the tests. Open your solution from Source Control, and verify that the tests do appear inside the test lists (and not as broken links). If they don't, include them and check-in the vsmdi file again. In general, the process that you can fo ...Show All

• Visual C# create object on another thread

  Hi, I need to be able to create objects on a designated thread. This thread waits and whenever a request comes from another thread, it creates the desired object, and returns it. The objects I need to be created are derived from Form, so it matters on which thread it gets instantiated. So, essentially, the main thread could do something like: MyForm f = FormsManager.Create(typeof(MyForm)); Where MyForm has a default constructor. Behind the scenes, the Create method switches to the forms thread and instantiates the requested form, and then returns it to the calling thread (all of this, as you see, is transparent). I need to know how to switch from the main thread to the forms thread, and how to return the result (the created form) back to t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACTENGINE_E_FAIL on XACT3DApply() call

  Hey all, I'm having an interesting problem where when it executes the BOLD piece of my code, everything else is returning S_OK, but you want to see it anyway: // Prepare the sound this->pSoundBank->Prepare(m_pCueIndices[nRandom], NULL, NULL, &pCue3D->pCue); pCue3D->vEmitterPosition = vPos; // Use one emitter over and over again that's what we're trying here m_pManager->GetManagerEmitter().Position = pCue3D->vEmitterPosition; // Let the engine calculate dist between listener and emitter, check for failure hr = XACT3DCalculate( m_pManager->Get3DAudioHandle(), &m_pManager->GetPlayerListener(), &m_pManager->GetManagerEmitter(), &m_pManager->GetDSPSettings() ); if (FAILED(hr)) ...Show All

• SQL Server SQL 2000 and 2005 side by side

  I was running sql 2000 for months before the release of sql 2005. I cannot upgrade any old databases on my test server but new applications are to be designed for sql 2005 database. I installed sql 2005 onto my server but for some reason I cannot get the enterpise manager to start (when I doubleclick C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe the splash screen displays for a fraction of a second and disappears). Can I run 2000 and 2005 side by side How can I get the enterprise manager to start Ackim It will be a problem in having 2 SQL versions client tools, you will not be able to open SQL EM when SQL 2005 is installed (server side). You migth try installing SQ ...Show All

• Visual C++ CallProcEx32W

  I failed in linking to the 16-bit kernel function " CallProcEx32W " with Borland C++ I am using. It was fine for other functions like "LoadLibraryEx32W", "GetProcAddress32W ", etc. Could you help me in solving this linking problem -Jeremy Hello Re: CallProcEx32W Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• .NET Development search words sequence in a string with regular expression

  HI, I've got some strings that contain the following text: 1) "That film is very beautifull". 2) "How much beautifull is the film ". 3) "The film is boring". I need, if it is possible with RegEx, to search if the string contains "film" AND "beautifull". I've tried with the following pattern: "film.*beaut.*", but IsMatch method returns only 1) I'm not interested in the exact sequence of the words. Can I achieve this with regex I know that I could do "(film.*beaut.*)|(beaut.*film.*)" but the number of the words to search is variable, so i don't want to perform all the possible combinations of the words in the search pattern. Thanks in a ...Show All

• Software Development for Windows Vista Interface inheritance and property Binding DialogBox: Bug?

  Hi all, here is my class hierarchy: I've got the class WorkerObject that implements the interface IWorker the interface IWorker inherits from the interface IPerson My workflow have a property IWorker But when I try to bind an activity property to a field of my IWorker property, I can't see the fields of the IPerson interface. I've read that WF is strongly typed but I don't think it's a normal behavior. What do you think of this Antoine Hi Tom, I agree with you that it is a .Net general issue, but in this case, it really limits us. I can't even bind manually the property of the parent interface... Can you tell us if you plan to change this behavior for the final release of WF Thank you Antoine ...Show All

• Visual Studio Team System programmatically merge branches in source control

  how do i programmatically merge branches in source control. Regards, Guru Thanks for the reply, Could you please help me with the links, it would be of great help. regards, Guru ...Show All

• Windows Forms ClickOnce and dotNET Framework 3.0

  Is there a fix to deploying a clickonce application with the prerequisite of the dotNET Framework 3.0 set Everytime I select it, I get the following error and the application won't publish. No 'PublicKey' or 'Hash' attribute specified for file 'NETFX30\Dotnetfx3.exe' ...Show All

• SQL Server SaveAs/Export

  Is there away with the reports to code to have them export into a excel template (a specific one) and have each report go into a different tab When I run the reports manually I can save to excel put not a pre-existing template. Each report has 3 to 12 stored procedures it needs to run so I am just not sure how to accomplish this task. Thanks in advance! Stokh OK, I'm not sure what you're asking for anymore. If you mean to ask if there's a way to do programmatic changes to a query at runtime, the answer (as far as I know) is no. But it sounds like RS can do what you need. Basically, you have the master report which takes a parameter, client_number or whatever your differentiator is. That parameter is used in a query on ...Show All

• Visual Studio 2008 (Pre-release) Has anybody connected to WebLogic server using WCF client?

  Has anybody connected to WebLogic web service using WCF client Yes, you should be able to create a WCF client with the wsdl created by the WebLogic service and use it like any other client. What is your scenario Are you using security What problems if any are you seeing Thanks. ...Show All

• SQL Server How to Send a T-sql data along with notification.

  My SSNS sends an email with the following details. Attention sales team: Order ID : 47 Order Date : 8/26/2006 8:40:23 AM Customer ID 2005e4 This is an auto mail.Please do not reply to this message** ========================= I want the following data is also append to the above message which is returned by a T-sql query. Product ID ProductName OldQuantity New Quantity 1 Glucose 677 509 2 Anotopozin 167 159 3 Clotimazole 456 450 4 Citrin 30mg 77 23 5 Avil 4mg 8000 5678 6 Becozules Z 4567 2469 So,where i have to write the T-sql query so that i ...Show All