Dmitriy Vasyura - MSFT'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 I am trying to work out on the performance issues in this approach - In this approa ...Show All

• Visual C# How can I traverse a treeview and delete every node that deosn't have child?

  Hello, I am wondering how can I traverse a treeview and delete every node that deosn't have child. Please help. Thanks. You have two options. You can traverse by index in reverse through the TreeNodeCollection and remove them as you find them. Or, you can loop through them and store a reference to each one found in an array or collection. And then afterwards use the Remove method on each item in the array ...Show All

• Windows Forms How do i draw a line just like VB6 but in .NET ? Any control available..

  is there any control like we use to have in Vb6 to draw a line witch control do i need to import for that thank you There's a free line control in the gallery: <a href="http://www.windowsforms.net/ControlGallery/ControlDetail.aspx Control=105&tabindex=9" ...Show All

• Visual Basic Change Font Style

  Hi, I am a beginner in VB.Net and want to ask a question. I hope somebidy can help me. I want to change the font style from a text in textbox by checking a checkbox. When checkbox Bold checked, the text in textbox change to Bold. When checkbox Italic checked, the text in textbox change to Italic. Etc, etc..... I have my code here: ---------------- If tbxTeks.Font.Bold Then tbxTeks.Font = New System.Drawing.Font(t ...Show All

• SQL Server Teradata, SSIS OLE DB Source error (0x80040E21)

  I am trying to use SSIS to pull data from teradata to SQL2005. 1. When setup ole db source, firstly i setup the connection manager. I tested the connection to teradata, it prompted Okay without problem. 2. then, there are 4 types of data access mode for selection.     If I select view directly, it works fine for copy specific view directly. But if I select SQL command(or from variable), it will prompt an error msg as below Error at ...Show All

• Windows Forms MDI and child forms

  All the forms I place in the MDI are the same size. I am trying to figure out how, when a form is placed on the MDI, no scroll bars appear or rather, the child form fits perfectly in the MDI, has no scroll bars and also, the background of the MDI can not be seen around the edges of the child form. I can do a lot of resizing and make the MDI background the same color, but seems to me a lot of trouble. And, using VS.Net 2003 and C#. Th ...Show All

• SQL Server Breakpoint doesn't work

  I've got a breakpoint in a script task. The script task executes successfully but doesn't break. Short and sweet this one. Anyone any idea why it might not -Jamie SSIS does not currently support breakpoints in script components. You will need to put some logging information in your script component see my post http://www.sqljunkies.com/WebLog/simons/archive/2005/08/03/SSIS_Script_Component_Debugging.aspx ...Show All

• Visual C++ Thread Synchronization

  Hi I have Four Thread Function I want to execute these function sequentially How do i do this ThreadFun1() //when it complete start second one and so on.. ThreadFun2() ThreadFun3() ThreadFun4() all functions are in different classes thanx Manoj Jangid Just start them in one thread one after another. If you want to execute them sequentially there is no need to have separate threads! ...Show All

• Windows Forms No Animals teleport to my machine.

  Hello there! I've already read a lot of these problems on other postes but none of the solutions seems to apply. I'm behind a firewall, the 50000 port is redirected to my machine and the redirection seems to be ok according to the online Port&n ...Show All

• .NET Development Problem about ILMerge

  I have a problem when I merge a assembly. I receive this error message : An exception occurred during merging: Index was outside the bounds of the array. If I exclude that assembly, everything is fine. What can I do with that Thanks. I'm not intimately familiar with ILMerge, but you can also look into using the VC 2005 C++ Linker. http://msdn2.microsoft.com/en-US/library/y0zzbyt4(VS.80).aspx It allows you to code in multiple l ...Show All

• Windows Forms Split Spool File

  Hi all,     I would like to seek some advice on manipulating a spool file (say contains a 10 pages MS Word doc, printer A). I am able to read a spool file and generate an image for each page. I am currently trying to sp ...Show All

• Windows Forms Restart Application Button

  Hi, Is there any function I can use to to restart an application Thanks, Can you provide more details about what you're looking to do   For example, are you looking to restart a different application (e.g. setup an application that will restart Microsoft Word), or an application that will restart itself   If the intent is to write an application that restarts itself, what is the driving purpose   ...Show All

• Visual Studio Does C# express support SCC API

  1. I would like to use source control with c# express, suggest me some options.   2. Does C# express support SCC API Regards Aslam Hi Chris, Yes, the Standard, Professional and Enterprise products fully supports MSSCCI (Microsoft Source Code Control Interface) interface. A source control provider implementing MSSCCI use the UI (checkin, checkout, change source control dialogs, etc) provided by VisualStudio (same as in previou ...Show All

• .NET Development SQL and Variables

  How could i place variables into an INSERT statement For example say the variable name has a value in it. How would i place this into an sql statement so i can insert the value into the name field of a database This link should give you a starting point for seeing how parameterized statements work: Updating the Database with a DataAdapter and the DataSet http://msdn.microsoft.com/library/default.as ...Show All

• SQL Server SubTotal

  example: Account Sales New John Doe 1,000,000 George Bush 2,000,000 Juan Luna 3,000,000 6,000,000 Old Michael Tell 5,000,000 Billy Banks 2,000,000 7,000,000 where Account and Sales are table columns, New and Old are group names. i want to display the total of the group. ...Show All