Sohail.Kadiwala's Q&A profile

• SQL Server SSIS - Importing varchar from Access into SQL2005 as varchar

  For the life of me I cannot figure out why SSIS will not convert varchar data. instead of using the table to table method, I wrote a SQL query so that I could transform the datatype ntext to varchar 512 understanding that natively MS is going towards all Unicode applications. The source fields from Access are int, int, int and varchar(512). The same is true of the destination within SQL Server 2005. the field 'Answer' is the varchar field in question.... I get the following error Validating (Error) Messages Error 0xc02020f6: Data Flow Task: Column "Answer" cannot convert between unicode and non-unicode string data types. (SQL Server Import and Export Wizard) Error 0xc004706b: Data Flow Task: &quo ...Show All

• SQL Server SSIS interview questions.

  Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions. Thanks These are the questions that i might ask: 1) What is the control flow 2) what is a data flow 3) how do you do error handling in SSIS 4) how do you do logging in ssis 5) how do you deploy ssis packages. 6) how do you schedule ssis packages to run on the fly 7) how do you run stored procedure and get data 8) give a scenario: Want to insert a tect file into database table, but during the upload want to change a column called as months - January, Feb, etc to a code, - 1,2,3.. .This code can be read from another database table called months. After the conversion of the data ...Show All

• Windows Forms Dynamic Graphics

  Hi, I'm developing a windows application for Tablet PC. I have a tab control on a page and many tab pages in it. When user fills data and saves, all the tabs that fails the validation should be marked (the tab page header background should be changed which will easily visible to the user) I tried using CreateGraphics and using FillRectangle to fill the boundary of the tab page exposed by Bounds property but it's not working because I found that Graphics can only be used in OnPaint event. The question is: Is there a way Graphics can be handled dnamically without being written in Paint related events Thanks, Shyam Hi, a_shyam41 I write this sample for your information: using Syste ...Show All

• Windows Forms Problem With KeyPress in DataGrid

  Hello, How to Respond to KeyPress event of  DataGrid when Enter/Tab is pressed. There isn't any easy way to do this. To trap the Enter/Tab key you'll need to override the DataGrid::ProcessDialogKey method. It gets more complicated if you need to trap other keys. You'll have to add a table style with columns style. For each edit control corresponding to the column style the you'll need to handle the TextBox::KeyPress event. -mark Program Manager Microsoft This post is provided "as-is" ...Show All

• Visual Studio Ruby Plug-In ?

    Ihave been really impressed with Managed code (C#) and Visual Studio over the last couple of years. But I am now pretty impressed by Ruby (and the RAILS Web fraemwork) Unfortunately the best Editors and few IDEs for Ruby seem to be weak  Java implementations, not a patch on the Visual Studio experience. I know Ruby is a very dynamic language, not so well suited to Visual Studio, but a Ruby Plug-In for Visula Studio, with robust intellisense, auto formatting, and common (RAILS) generator macros would be really great. It would also show that Microsoft is open and prepared to support 'best of breed' third party languages.  Anyone know of any work on Visual Studio Ruby Plugins Jules   ...Show All

• Visual C++ Video Tutoirals?

  Hello, Can anyone tell me if there are any video tutorials on VC++ 2003 Basic Win32 or MFC video tutorials online Thanks! http://www.fz-juelich.de/video/cpp/index.html might be of some help, though I do believe it targets C++ itself rather than the win32 apis. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with adding color value to custom vertex

  It may sound ridicolus but I have problems with this for 2 days already... I am fed up with it... The biggest problem is that I cant see what I do wrong, even after reading houndred times other vertex declarations. I have made few custom vertex structures and they worked but the only problem I have, is when I try to add color to vertex. Of course I use the type Color in my vertex and this is my declaration (part) #region Attributes private Vector4 m_Position; private Vector2 m_Texture; private Color m_Color; #endregion #region Static Attributes public static readonly VertexElement[] VertexElements = new VertexElement[] { new VertexElement(0, 0, VertexElementFormat.Vector4, VertexElementMethod.De ...Show All

• SQL Server Microsoft report builder is a very BAD product

  This product can't make a report selectin measures from more then on cube at the same time crossed by to shared dimensions, it's a shame. Please don't say you have a web base ad-hoc query if you can’t even do same basic stuff like this. Following the same line of thought, you can say that Excel2007 is bad, Proclarity is bad, and in general, most of the commercial OLAP browsers are bad. Can you mention one OLAP browser that supports browsing multiple cubes While waiting for the perfect browser, consider linking the measure groups if you need to do some cross-cube analysis. That said, I aggree that the SSAS team has left substantial ground for improvement for UDM ad-hoc reporting with the ...Show All

• Visual C# Classes with the same name in the same namespace....

  Hi All, In my solution I have 2 classes with the same name in the same namespace. This was legal in VS.net 2003 (.Net 1.1) and all the compiler did was to raise warning about this problem. However with VS.net 2005 (.Net 2.0), this has changed it now throws a compiler error for the same. Is it possible to get around this issue in any way without having to change the class names... Thanks in Advance andypai I don't think that this is possible. But why do you want to have multiple classes with the same name in one namespace   Anyway, it is not a good practice to do this, even if it was possible in .NET 1.1 (never tried). For example, what would happen if you want to do a cast from an object to your class li ...Show All

• Visual C# Get selected text form MS Office Word

  hi everyone, i want get selected text from ms office word. i use Ms AA 2 component but i dont get any thing . please give me solution. Hi, I guess you want to paste something from word to somewhere else in program. If I've misunderstood you, pls let me know. If so, reference to clipBoard in .NET Framework: http://msdn2.microsoft.com/en-us/library/c2thcsx4(VS.80).aspx Thanks ...Show All

• SQL Server Keeping Database as small as possible ?

  Hello everyone, I have a winform application with C# front end and sql express 05 backend. In this database i have a table that holds manufacturer provided pricing and the manufacturers we work with update pricing constantly. We have one table called "manufacturerpricing" which we are constantly inserting and deleting pricing records to/from to keep manufacturer pricing up to date. We may insert and delete as many as 2,000,000 records per month into this table. This works perfectly fine and we have no problems here at all. But with that being said, I am worried about the size of the database growing out of control due to temporary space etc. The database just keeps getting bigger and bigger. How do I run so ...Show All

• Visual Studio Express Editions install cl compiler

  Hi, i dowloaded and installed vc++ 2005 express edition. Now I need to install only the cl compiler on client machines. Please let me know what files should i copy and what env. variables need to be set on that machines. Thank you You are right. But Borland C++ compiler could not be used for commercial use. So far what i found is that only cl is free, reliable and could be used commercially . ...Show All

• Visual Studio Help With Installing Visual Studio 2005 Professional

  Could someone please tell me step by step what I need to do in order to install Visual Studio 2005 Professional. I have downloaded the En_vs_2005_Pro_90_Trial.img file but from here I am completely lost. I am looking for some way to install this program into my computer without having to purchase the ISOBuster software or possibly any other software for that matter. I am a total newbie to any sort of file like this (.img) and just about everything I have read concerning it confuses me. I do have a CD burner but I don't even know how to use it, so when I read about burning the VS2005 file to a CD I am lost here also. If someone could explain in laymen's terms how I can install this file into my machine I would greatly appreciate it ...Show All

• Connected Services Framework Evaluating CSF

  I have a heterogeneous environment: Windows and Linux. My web services on Windows use .asmx, and I'm currently upgrading those to WCF. The other web services are just XML-RPC services on Linux systems. Some in my organization want to port all those to web services on J2EE. My question is, with which J2EE systems is CSF competitive, and how can the Linux side of the house create well-enabled services that are CSF-compatible Though any web service regardless of the platform can be consumed by CSF, we advocate for WS-* complaint web services. CSF ships with WES Tool kit that helps build well enabled services on .NET platform. Well enabled service (WES) defines interfaces related to concepts like Healt ...Show All

• SQL Server Editing in Querry Analyzer not in EM

  Hello, In SQL if we want to edit a row in a table then we have two ways to do the same, 1. Execute a command to Update the records in sql through querry analyzer. 2. Go to enterprise manager and then open the table and update a new row. But can't we do the editing in the querry analyzer is there any way to do this. That means i select all the records from my table using the following querry. Select * from MyTable and then performs editing in the querry analyzer without executing any update command and without using the Enterprise manager. Can we do this Bye and TC Yes. You can do this. In the Query Analyzer, expand the Object Browser (left side pane of your QA window) upto your desired table. ...Show All