Juan Foegen's Q&A profile
SQL Server SSIS package designing and execution in BIDS is very slow
Hi, I have created a package that has 2 SQL Execute Task, One Loop container, 2 Data Flow tasks, 1 Foreach loop container, 1 ftp task. The data flow tasks has 1 oledb source, 1 flat file source, 1 row count transformation, 1 recordset destination and 1 oledb destination. When I load the package into BIDS it takes 125 MB of memory and then everything is slow, the properties panel slides in slowly and exists slowly. The object is the packages are not painted properly. to make changes and run takes lot of time. Am I doing anything wrong here Why is it consuming so much of memory Thanks in advance for your help. Regards, $wapnil ...Show All
Visual Studio Team System Configuration Manager not visible in IDE
Guys, I do not see Configuration Manager in IDE of VS 2005 Team Suite, and basically cannot switch between Release and Debug mode for the code. I have checked all possible placed and I do not see how I could make it to appear. Am I missing something I am also not able to see the 'release' option for my Web Service project.... External users will get 'debug.assert' messages.... Not Good. PLEASE GIVE FIX TO THIS! Regards Bjorn Sigurd Johansen ...Show All
.NET Development Problem with Environment.GetLogicalDrives method and Windows Service application
Hello, I am using the following method Environment.GetLogicalDrives to access all available drives on my system. This method works just fine when I run it inside the Windows Form application; however, when I run the same code inside the Windows Service application it returns only local drives without the mapped network drives. The Windows Service application runs under my user id. Thanks Tom Hello nobugz, Thank you for your reply. I actually implemented the API call to the GetLogicalDriveStrings method and I got the same result. Based on the article, I assumed that the drive is mapped in the LocalSystem context; therefore, I tried to use the drive letter, which was already assigned t ...Show All
.NET Development Sending and Recieving Data over the Internet
Hello, I'm trying to code an Online game and I'm stumped as to how to make the Client software communicate with the server software I made. I know that I should use the Net.WebClient for something...Please give me some help, With this I can launch the beta of my MMORPG! Basically I want to constantly transfer 16 variables containing Player data over an internet connection. I want the server software to be able to manage and distribute player data to all online clients. For example: Seeing another player move close to you and chat. Thanks In Advance! You probably want to use the System.Net.Sockets.TCPClient or UDPClient objects. You'll pick a port, or range of ports (search for assigned ports and pick from the unassigned range) and se ...Show All
.NET Development timeout expired failed to start instance
I have a C# windows app created with vs2005 on windows xp pro with sql 2005 server express installed ( it uses a database ) I create a deployment project then install the app on the machine Every so often - quite rarely but enough to worry about - usually just after a restart - when I start the application I get a timeout expired - something about failing to connect to an instance - I am assuming it is because the database engine has to start up and then it has to creat an instance and all this just exceeds so time limit - I tried putting "Connection Timeout=300" in the connection string in the app.config file - it did change the sqlcmd.connection.connectiontimeout to 300 but it did not get rid of this intermitant probl ...Show All
SQL Server Printing at the bottom of report
I need to print a subreport at the bottom of the last page of the report and I can't find a way to do it. Can't use page footer for it because subreports are not allowed in the page footer. Help please!!! Will, When I place it underneath the main table, it simply puts the subreport at the end of the report. So if main report ends in the middle of the page, my subreport will be in the middle of the page too. I need it at the very bottom of the page. ...Show All
Visual Studio sku011.cab...problem resolved
dear all, good day!... lately, i was having a problem with sku011.cab.and then i looked up at google...and i followed all the instruction...guess what ...my problem with my computer was gone...i've just changed the binary number from 2 to 0.how funny is it!... thank you very much!.... regards, Clyde. ...Show All
.NET Development SchemaImporterExtension - machine.config
Hi! I created the derived class like shown in the sample. Now I can't get the debugger to step into my class. My machine.config looks like this (in contrast to what the sample is assuming I guess): < configuration > < configSections > < sectionGroup name = " system.xml.serialization " type = " System.Xml.Serialization.Configuration.SerializationSectionGroup, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " > < section name = " schemaImporterExtensions " type = " System.Xml.Serialization.Configuration.SchemaImporterExtensionsSection, System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " /> & ...Show All
.NET Development Is it madness to intercept serialized XML in a client proxy?
I have a question that hopefully someone in the forum will be able to answer: I have a web method that returns an entity (lets say an Address entity for example) The address entity has the following properties: Address1 Address2 Address3 Address4 Address5 Postcode (AKA Zip) My client consumes the service, calls the web method via the client proxy and makes use of the returned Address object. I have 2 consumers of this service. The first, as mentioned above makes use of the Address entity. The second however will make some modifications to the object, and then pass the object on to another service. My question is this: Is it possible to receive / intercept the xml of the serialized Address object (perhaps via the use of a ...Show All
Visual Basic AccessKey for Custom Button Control in VB 2005
Hi all, I have a custom button Control converted from VB 6.0 to VB 2005. I need to know how to set accesskeys property for the custom button control. This is the error i get in the converted project. 'UPGRADE_ISSUE: UserControl property UserControl.AccessKeys was not upgraded. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm keyword="CC4C7EC0-C903-48FC-ACCC-81861D12DA4A"' Thanks, Hello Mick, Me.OnClick did not fire the click event of the button control. I had five custom button controls in the sample application. After the if condition is passed, the Me.OnClick did not fire the onclick event. Also what is the difference between Me.OnClick and MyBase.OnClick Can they be used interchangeab ...Show All
SQL Server Is Management Studio Express compatible with Visual Studio?
I have installed Visual Studio 2005 which includes SQL Server Express but not the Management Studio. Can I install SQL Server Management Studio Express ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Dream Build Play today?
Well it's just gone 9am UK time and as it's the last day of January I assume that the Dream Build Play website will go live today Michael Morton wrote: They said January. They never said anything about 2007. :) good one. ...Show All
SQL Server MS Sql Server Management Studio SP2
I am experiencing a problem with functions when pulling from a sql2000 database that I found information indicating that it was fixed with SP2. I'm trying to find a Service Pack 2 specific to SQL Server Management Studio and am having some difficulty. I found service pack 2 for sql 2005 but nothing specific to Management Studio. Does anyone know what I should be looking for specifically or where I might find sp2 for management studio I think you are mixing some things up. SQL Server 2000 has SP4 which fixes problems around the service and some client issues. The administrative console for SQL Server 2000 is Enterprise Manager not SSMS. Actually right now there is no SP2 available for SQL Server 2005. You s ...Show All
SQL Server Newbie question here - stored procedures
Hi I just installed sql server 2005 for the first time today. Anyways I have a bunch of stored procs from an application i developed on the SQL 2000 server. Anyways I am having a problem with one of my stored procedures. CREATE PROCEDURE ProvinceRetrieveAdHoc ( @whereClause VARCHAR ( 256 )) AS EXEC ( "SELECT * FROM tblProvince WHERE " + @whereClause ) RETURN GO However this isn't working, I am getting this error: Incorrect syntax near 'SELECT * FROM tblProvince WHERE '. Now I am guessing the EXEC statement must have changed, as every stored proc that uses the exec command errors out with this same error. All my other procedures run just fine. Can anyone please tell me how to fix it ...Show All
Visual C# Displaying a Generic.Dictionary object in a PropertyGrid
Hi, I have a property in one of my classes that returns a Dictionary object: public abstract partial class NonStationary : Structural { protected NonStationary( string name, Shape. Shape shape) : base (name, shape) { } private Dictionary < string , Motors. Motor > _motors = new Dictionary < string , Motors. Motor >(); [ BrowsableAttribute ( true ), ReadOnly ( false ), TypeConverter ( typeof ( CollectionConverter )),] public Dictionary < string , Motors. Motor > Motors { get { return _motors; } } } There are four classes th ...Show All
