Venu_nair's Q&A profile

• SQL Server Merge Join (Full outer join) never finishes.

  I have a merge join (full outer join) task in a data flow. The left input comes from a flat file source and then a script transformation which does some custom grouping. The right input comes from an oledb source. The script transformation output is asynchronous (SynchronousInputID=0). The left input has many more rows (200,000+) than the right input (2,500). I run it from VS 2005 by right-click/execute on the data flow task. The merge join remains yellow and the task never finishes. I do see a row count above the flat file destination that reaches a certain number and seems to get stuck there. When I test with a smaller file on the left ...Show All

• Visual Basic Create Folder.

  Hi,  I want to create folder and subfolder from vb during runtime. Is it possible .  If anybody knows  please, help me. Bye,     It's easier using the new My namespace: My.Computer.FileSystem.CreateDirectory("C:\the new folder") Steve Hoag Visual Basic Express ...Show All

• SQL Server Sql to FoxPro Export

  I have 2 packages, one to import data from Foxpro to Sql and another to send the data back from Sql to FoxPro. The time it takes to execute the package that moves 2 million rows of data from FoxPro to Sql takes about 18 to 25 mins. Not bad. However, moving approximately the same number of rows from Sql back to FoxPro takes about 8 hrs. Not acceptable. I have tried several things with no luck. Any advice would be appreciated. V You need to identify where the bottleneck is. I recommend you read the whitepaper that I have mentioned here: http://blogs.conchango.com/jamiethomson/archive/2006/04/09/3594. ...Show All

• Visual Studio VS2005 installation on Vista beta1

  When i tried to install VS2005 beta2 on Windows Vista beta1, a error occurred and the installation was terminated. Does someone know why Take a look at http://blogs.msdn.com/quanto/archive/2005/08/02/446689.aspx  for a workaround. ...Show All

• Visual C# Difference in Arrays!

  which difference between is : int [][] Matriz;    //caso01   int [,] Matriz;     //caso02   ...Show All

• SQL Server Filter Records returned on report builder based on User LogOn

  Dear Anyone, Is there a way to filter the records returned by a report model in report builder depending on the actual user that is logged on the report If so, how do we go about this Thanks, Joseph Yes, this can be done either by building a regular filter of using security filters. In both cases filter condition will be based on the Report Builder function GetUserID FYI: there is a known bug in security filters  (not regular filters) that will be fixed in Yukon SP1 ...Show All

• SQL Server DB Replication on SQL Express edition?

  Dear All, I have plan to use SQL Server Express Edition, is it possible to have DB Replication features in this edition .. please advise.. Thanks a lot in advance Regards Winanjaya Hi, depends on the kind of replcation you need, the feature comparison (also with the replication features) can be found here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Problems when connect sql2005 locally

  Hi All, When I use asp.net 1.1 to connect sql 2005 enterprise server which just enable local access option instead of remote, I got error message to say database server is not avaiable. I use following connection string user id=abc;password=abc;server=(local);Integrated Security = SSIP; user id=abc;password=abc;server=.;Integrated Security = SSIP; Actually, I used default instance, and ASP.Net and database server are in same server. Everything is fine when I change connection string as user id=abc;password=abc;server=servername;Integrated Security = SSIP; Frank, This is a known issue when ...Show All

• .NET Development Excel workbook to XML

  I have basically a calendar as a sheet in Excel. I want to conver that data to XML so I can use it in a web page, attached to a DataGrid, as the built-in Calendar control seems to be limiting. Is there an application add-in or a utility that will take the columns and convert them to an XML file so that I can then have the DataGrid display it out as a Calendar Or is there something I am overlooking in Excel, when I attempt to export it to XML it says I need a map, but I don't understand what those map's are, I assume they are basically a template. Maybe someone can point me to an "Idiot's tutorial on XML" Thanks for your ti ...Show All

• Visual Studio Team System Error in profiler report generation

  I am getting the following error (message box) while preparing report. What should I do to fix it --------------------------- Microsoft Visual Studio --------------------------- Symbol Engine: Loading symbols for module 'd:\School\bio\projects\Approximation\LPMotif\Release\LPMotif.exe' Symbol Engine: Loading symbols for module 'C:\WINDOWS\system32\kernel32.dll' Symbol Engine: Loading symbols for module 'C:\WINDOWS\system32\ntdll.dll' Error VSP1740 : Error when trying to serialize symbol data   --------------------------- OK   --------------------------- ...Show All

• SQL Server Connecting Surface Area Configuration to server on Clustered Server

  I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition. Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhost\instancename, but reports the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...Show All

• SQL Server Problem making backup of an SQL Server database

  I want to make backup of an SQL Server database located on computer LAB3B-NT05 and I want the backup to be stored on another computer.  Can that be done The commands bellow works fine if I store the database on a local disk. exec sp_addumpdevice @devtype = 'disk' , @logicalname = 'Event_1' , @physicalname = '\\kbg2863\BackupTest\EventBACKUP.bak' GO BACKUP DATABASE Event TO Event_1 WITH FORMAT GO exec sp_dropdevice @logicalname = 'Event_1' GO When I execute BACKUP DATABASE Event TO Event_1 WITH FORMAT, I get the followin error: Server: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'Event_1'. Device error or device off-li ...Show All

• Visual Studio Express Editions VC-EE Redistributable Executable?

  Hi, I live in a country where ISP's have harsh restrictions on download usage. And would like to save a copy of Express Edition that doesn't require me to download 60mb~ every time I reinstall the program. Does anyone know if a "redistributable version" exists which would allow me to install it without an internet connection I ask this as nearly all other Microsoft software I've come across has this option. (.NET Framework, Service Packs, DirectX, etc) I admit I'm not very good at finding what I'm looking for :( The closest thing I could find was that page with the 500mb ISO files which probably included the 400mb worth of MSDN extras. Thank ...Show All

• Smart Device Development What event is fired when using a Pen to select a Control?

  Hi, and happy Easter all! I am creating a Forms application for a QTEK Smart Device and was wonder what event is triggered when I select a Control with a pen I can't seem to find a relevant event when searching through a controls event properties. Device: QTEK. CF: 1.1 Thanks Tryst I'm not sure if I understood your question. Are you using a Pocket PC (and you are using the pen to select controls) Which control are you trying to select If it's a button, the event button_Click handles it.. ...Show All

• Visual Studio Tools for Office I need a help with CMschart control!

  Can columns in a chart be divided into separate colored portions representing different variables Basically, it should act as pie chart as it represents percentages of a whole, only it looks as column chart. Thanx! Milos, I am sorry you are having trouble with this issue. You will get a faster answer by posting you question to a more appropriate forum or newsgoup as this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. Here is a link to resources that will help you: excel.programming newsgroup http://msdn.microsoft.com/newsgroups/d ...Show All