sabarish_s's Q&A profile

• SQL Server How to write Condition in the Conditional Split control in SSIS

  HI i need to write the Condition for Insert and Update Reccord depending upon the Prod_ID. How to write the Follwing condtion in the Condition Split pls Anyone give me the Solution    "  if   Prod_ID  Exist then  UPDATE  Records     if Prod_ID   Not EXIST then INSERT Records "     how to write the above conditon in the Condional Split Thanks  &  Regards, Jeyakumar.M chennai     RC_SSIS wrote: Thanks, Jamie. I'm not sure that I would want to use an OLE DB command for performance reasons, but maybe you can advise otherwise. I'll be dealing with 10-20,000 rows, and since an OLE DB command execu ...Show All

• Windows Forms Spalsh Screen

  Hey, In in properties of a project how do you select what form you want to be a splash screen I used the help in the compiler but I could not get an answer that worked... Thanks :) Ok, I got all that down, but how do I make it so that the spashscreen form opens up first ... ... ...wait...could I just open up program.cs and where it says: Application .Run( new Form1 ()); change form1 to the name of the splashscreen form or would that cause any problems in the future Thanks :) ...Show All

• Visual Studio Express Editions App similar to HyperTerminal

  Is it possible to create a simple application similar to HyperTerminal (that comes with Windows) in VB2005 If so, could you provide me with some code to get me started, or point to some info on the net Thanks... See http://www.innovatic.dk/knowledg/SerialCOM/SerialCOM.htm ...Show All

• SQL Server Stored procedure activated more than once

  Hi guys! Is it possible for a stored procedure to be activated more than once even if a message is sent only once After sending the message, I check the sys.dm_broker_activated_tasks and see that it activates more than once. Is there a way for me to prevent this from happening Thanks a lot! :) That stops it activating more than one at any one time. But that doesn't stop the procedure being activated twice, one after the other, even though there are no messages on the queue when the second is activated. ...Show All

• Windows Forms Need some information from all you smart follks... :)

  Let me tell you a little about myself. My name is Dave Scott Anderson, I am 16 years old and have been programming in C++ for 2 years, C# for a couple months, and HTML for over 5 years. I have become quite addicted to C# programming with Windows Forms. I have finally decided that I want to purchase the full version of Visual Studio...But heres the problem... Where are Windows Forms technology headed Would it be a waste to purchase VS2005 since Microsoft is going to come out with Vista and the .NET Framework 3.0 I need advice on this.... Programming is what I love to do. And I prefer to be up to date with technology... Sorry if this is in the wrong forum... but it is related to Windows Forms, so I posted it here. I have actually cr ...Show All

• Visual Studio Express Editions Help: How to create new project from old? or Source Control Tool?

  I would like to create a new project from an existing one. For example, Test2 from Test1. Is there a way of changing all the names on the files and all the occurances of Test1 in the files Having this automated would be helpful, because I build in small steps, and so will use the process many times. I know I can copy the Test1 folder, subfolders, and files to a folder Test2, and the rename files. And I have an editor that will replace text in all files in all subfolders. But even that can be tedious. Perhaps a source control system might be helpful. Is there a free one that will marry with VS 2005 Express Urm, yes, you can't do it inside the IDE. No, AFAIK, you can definitely do it outside the IDE. If i ...Show All

• Visual Basic How to hide a folder or File

   I want to hide a file or folder in windows so that it can't even seen by command line or explorer.  I am not talking about hiding a file or folder by simply changing the attribute in properties window.  I want to hide in such a way so that no one can access my folder without the use of software.  can anybody give me any idea how can i do this thanks What you are describing, is basically how a RootKit works, so I would suggest backing up all your data before you go looking for that sort of code The only stuff I've seen hidden like that (apart from rootkits, of course), are NTFS management folders and the driver from Daemon Tools. ...Show All

• SQL Server Trying to hide/obfuscate TSQL code

  Hi there, we are porting a huge PL/SQL(on Oracle 10g) application to TSQL (SQL2005) right now and we will offer a test drive for download. In Oracle we could "obfuscate" the PL/SQL code with a hash, so nobody can see the PL/SQL statements after the encryption. Is there something like that for SQL Server 2005 as well which can not be overidden by a local admin (like with changing a password for example) We have spent 5 years in writing SQL code (it is huge) and don't really want to spread the source all over the internet. Any help is appreciated. Niko Hi Niko. Is the code encapsulated in stored procedures If so, see the WITH ENCRYPTION option that is part of the CREATE/ALTER PROCEDURE syntax ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I dont find the XNA Launcher

  Hello, I'm french and i dont find the XNA Launcher on XBox Live Market, is it a bug or is XNA Launcher available only for US Else, were could i download it Thanks in advance The launcher isn't enabled yet as the XNA framework is still in beta. I believe December 11th or there abouts is when you will be able to purchase a creators club membership and thus run your XNA creations on your very own 360. I should also mention that the launcher isn't part of xbox live but, is integrated into the 360 dashboard. ...Show All

• Software Development for Windows Vista Confused, what is the relation between MSDTC timeout and System.Transaction Option?

  What I seem to be seeing is that when I create a System.Transaction with: transactionOptions.Timeout = new TimeSpan (0) but keep the COM+ Explorer MSDTC timeout at 60sec it timesout at 60secs. I don't have have Enterprise Services attribs on my code. What's happening or am I just going mad! I've run a quick test application that requests an infinite timeout, does some work, sleeps for 65 secs and then commits. I've set my DTC timeout to 60secs and the code works fine. I can see the Tx in the DTC statistics come and go so I don't believe it takes the lesser of the two values. So I'm still dazed and confused! ...Show All

• SQL Server SQL Everywhere - Utter Dissapointment!

  On the surface, SQL Everywhere seems like a great way to reuse code from an enterprise app using SQL Server in a SMB or home office app needing a more But in experimenting, I have been utterly dissapointed in SQL Everywhere. Key reasons for my dissapointment are the inability to write Database Independent codeusing System.Data.Common . There are instructions for doing this in the MSDN. But do they only apply to non Microsoft Databases I have the following grievances. Are these things that Microsoft plans to fix, or do they plan to leave SQL Everywhere as an inferior product 1. Limitations of query language are not well documented nor understood. SQL Everywhere uses a "subset of Transact-SQL syntax". I have not seen it do ...Show All

• Visual Studio Team System Web.Config Version Control?

  I am trying to find the best way to go about this. Right now our ASP.Net 1.1 project is under version control TFS. When we added the project our team used a web.config that is specific to the integration server, however, there are values that are specific to ones local development environment. Editing and saving the file requires one to check it out of version control and we would like to prevent this from happening, as we would to prevent our developers from "accidentally" overwriting the file. Am I making a mountain out of a mole hill here Part of me feels like I am but I would like someone else's opinion. Thanks in advance...   Lots of options: Do nothing. ...Show All

• Visual C++ destructor of global objects not called (CRT without managed code)

  Hi there, our MFC application uses a couple of own and foreign dlls (like stlport , xerces , ..). After porting it from Visual Studio 2003 to VS2005 the destructors of the executable's global objects are not called anymore. Those of the dlls still are! The problem exists in the debug and release version of the application. For analysing the error I created a simple new MFC application, forced loading almost all external dlls and put a break point into the destructor of "The one and only " global MyApp object. But the destructor of MyAp p IS called. I looked into the call stack and found out that the destructors of global objects are called by the CRT function doexit (file crt0dat.c). That function runs through an array of functio ...Show All

• Windows Forms Draw grid?

  Is there a way to draw a grid using Graphics I need the lines 39Pixels apart. (1 CM) Thanks, Hi, I don't know any function that would draw a grid for you but you could do a for to draw several lines using Graphics.DrawLine . ...Show All

• Smart Device Development Performance System.DateTime.Now

  Hello The API function GetSystemTime(out st); (PInvoke) is about 1500 faster then System.DateTime.Now; System: WinCE50 on ARMV4I TestCode: using System; using System.Data; using System.Runtime.InteropServices; namespace DateTimePerformance { public struct SystemTime { public ushort wYear; public ushort wMonth; public ushort wDayOfWeek; public ushort wDay; public ushort wHour; public ushort wMinute; public ushort wSecond; public ushort wMilliseconds; } /// <summary> /// Summary description for Class1. /// </summary> class Class1 { [DllImport("coredll.dll")] public static extern void GetSystemTime(out SystemTime st); /// <summary> /// The main entry point for the a ...Show All