Laxmikant's Q&A profile

• SQL Server Transferring Records from a table to multiple files

  Hi, I have a table - Student with 25 Million records. I want to transfer the records from the table to flat files. One flat file can contain only 1 Million record. So I need to generate 25 flat files with 1 Million in each file. Whats the best way to accomplish this task using SSIS. Any help would be appreciated. Thanks, loonysan This is an interesting problem. If the number of files to be produced is fixed at 25 then this is fairly easy. You'll be able to do that with a script transform that adds a surrogate key to each row ( http://www.sqlis.com/default.aspx 37 ) and then a conditional split which ...Show All

• SQL Server Howto connect to reporting service through C# application

  Hi, I created some reports in Visual Studio 2005 (only for reporting services) and I'm now developping a C# application in Visual Studio 2003. This client application should get the reports from the report server when the user has entered some parameters. I just can't figure out how to speak to the report server... There are some samples that I found for the 2005 enviroment but I can't get them to work on a Visual Studio 2003... Does anybody has a nice reference to other examples Greetings ...Show All

• SQL Server Extremely Poor Performance - Identical DB's but very different performance

  Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second. I took a look ...Show All

• Visual Basic Strange Issue with Excel Interop

  I have recently moved to 2005 Studio Standard edition and after some fighting initally with my laptop and it's issues with VS2005 and left over beta bits and so on, I have totally rebuilt my machine. In short = fresh copy of xp pro and VS2005 std and Office 2003 IIn VB 2003 I used to be able to add a reference to the Excel 11.0 library and then use the following line: Imports Microsoft.Office.Interop However that is not possible any more. Following the same steps I can only import the following: Imports Microsoft.Office.Core This presents a problem if I want to do this, because the Interop is not available: Dim x ...Show All

• Visual Studio Team System TFS Install failed!!!

  My installation failed and now I can't seem to find a way to remove TFS &/or repair the installation.  I am using Server 2003 enterprise, SQL Server 2005 CTP April, latest Sharepoint Services, have the necessary accounts and all required services are running. I installed this on a clean machine. One thing that might provide some insight is that I was unable to exclude SQL Server Reporting Services from Windows SharePoint Services management.  The error I got was: The virtual server that is referenced here is not in the config database. How do I uninstall or repair my failed installation ...Show All

• Software Development for Windows Vista Windows Workflow Jan CTP

  I just installed Windows Workflow January CTP. I noticed the API has greatly changed since the last released. It broke all the sample apps from the previous release I downloaded in December. Are there updated WinWF samples apps for the new release If there are, why didn't they get installed with the new release of WinWF How does one get them It is painful having to fix the old samples to get them to work. Also, is a separate forum or newgroup going to set up for WinWF just like the ones for WPF and WCF If you are referring to the online documentation, then you are correct.  The online documentation ...Show All

• Windows Forms Moving items in databound ListBox?

  I have worked out how to move items in ListBox, but it doesn't seems to work when the ListBox is bound to a DataSource.  How can i move items when ListBox is populated using DataSource property   well i can delete the current row using Delete method, but how can i add it back to list at different index. for eg if the u ...Show All

• Windows Forms General Question Web page look to windows forms application

  I have to create a client heavy application and I have a couple of questions. I have created ASP applications using C# and VB and also windows app using both however, this for this application they want it to "look" like a web based application (imagemaps, gridviews, etc) but it is going to be tied to a single computer because it will be accessing USB ports and various peripherals. Should I create a project in C# and select Windows Application and try to make it look like a web page or create a web site, force the user to load IIS and run it locally Is it a pain to access specific hardware like USB ports with a ASP based web site ...Show All

• Visual Basic Interaction w/ MySQL !!

  Greetings, I am attempting to make a windows application that among other things allows the user to view tables and edit their contents in a MySQL database.  I'm using VS 7, and i'm getting problems with the following.  I add in a new dataset to my project, in the development window it says drag components in this window from either the toolbox or the server browser.  Well I have the MySQL database I want to edit active in the server browser.  I drag the appropriate table I need to edit into the window and I get an error saying my data adapter type doesn't support ODBC.  Even getting VS to connect to my database was ...Show All

• Software Development for Windows Vista LoadDesignerLayout problem

  trying to use LoadDesignerLayout  to better present the layout of a statemashine workflow in the Workflow monitor sample. using ( StringWriter stringWriter = new StringWriter ()) { using ( XmlWriter layoutwriter = XmlWriter .Create(stringWriter)) { IList errors = null ; this .SaveDesignerLayout(layoutwriter, rootdesigner, out errors); string s = stringWriter.ToString(); XmlTextReader layoutReader = new XmlTextReader ( new StringReader (s)); this .LoadDesignerLayout (layoutReader, out errors); } } errors: "Could not deserialize complex property 'StateMachineWorkflowDesign ...Show All

• Visual Studio Global Assembly Cache Problems.

  Hi There, I have a single report application that I am attempting to publish.  When I install the application on my machine it works fine, but when I attempt to install on any other I am told that the installation requires:- CrystalDecisions.CrystalReports.Engine Version 10.2.3.600.0 installed in the Global Assebly Cache (GAC) first. I have looked within the project properties, at the references section but as far as I can tell the reference is there. Any help would be greatly appreciated.  I am running VS2005 Professional. Rob         Go to: Admin ...Show All

• .NET Development Resource names generated for IExtenderProvider

  This is a little esoteric - I hope someone can help me. I have written a component that implements IExtenderProvider that provides a property that is a StringCollection. When I make my form localizable, the resource names that are generated for the extended property dont include the property name which seems wrong to me (although not technically a bug since it works). This makes it rather hard to parse the .resx file (which I want to do for other reasons) To illustrate, I have a component (code below) that provides a property called "Sausages". When I attach this property to a control (userControl1) on a localized form, the CodeDom gen ...Show All

• Visual C++ String ^ to void *

  I'm building a managed wrapper in C++/CLI for normal native code. Here is a function from this wrapper that I'm having problems with: ERRORS SetOption( int nOption, String ^strSetting) { return (ERRORS) _SetOption(m_Handle, nOption, strSetting); } The native function accepts a "void *" as it's last argument. This could be an integer, string or even a function callback depending on the nOption parameter. How would I wrap this The problem is that I cannot convert strString to a void *. Would it be possible to use a more "lowlevel" type as the input instead of "String ^" Does something like "void *" exist in a managed version The closes ...Show All

• Visual C++ CDC Issue

  <wdhough@discussions.microsoft.com> wrote in message news:069f1a60-2d1e-46dc-8474-f2de281812e1@discussions.microsoft.com > I have an application that draws a diagram in the form of a bitmap > and then displays this in a window.  There are limits placed in my > code that do not allow  > the CSize properties cx and cy to be set to more than 32000 in > 'SetViewportExt' and 'SetWindowExt'.   You seem to labor under a mistaken impression that SetViewportExt and SetWindowExt somehow limit the size of the drawing. They don't. In fact, the absolute values you specify in ...Show All

• SQL Server URGENT, sqlServermanagementStudio can't find sqlExpress.Though it has apparently been installed

  hiya, I'm trying to install. I was getting an error relating to "sqlncli.msi" So, I: 1) extract sqlncli.msi 2) repair it 3) reboot 4) re-install Apparently, it installs successfully. 1) the sqlExpress service is running ( but I don't see the wee green icon in the sys tray) 2) I try to use sqlServermanagementStudio...I look for sqlExpress in the login page, but it can't connect. I am in a big hurry for this, should I unistall then re-install sqlServermanagementStudio I simply want to run sqlExpress locally on a machine, nothing fancy..Can I use a command to attach the database ...Show All