paoloTheCool's Q&A profile

• SQL Server Running out of disk space during SSIS package execution

  Hi all, I'm running out of disk space when running SSIS package. Is there any way to select where temp files are saved during package execution You may want to consider changing the cache, but you need to decide that in the context of your data set. If you have a lot of rows in the lookup target, versus a much smaller set of rows in the load, then reducing or removing caching would make sense. BTW, you can set the BLOB and Buffer Storage Paths, two properties on the Data Flow Task, but I suspect it won't help if the lookup cache is the issue. ...Show All

• Visual Studio Tools for Office Export SQL table into Excel...

  Hello there, does anyone know some easier way to export data from datatable to excel I'm using some foreach loop to write data cell by cell... It's working ok, but CPU usage is on 100% and a half giga of memory is used.. So, the question is: Is there any way to cut whole table and paste it to worksheet Or is better way to transform table first to XML and then decode into excel So folks, any good idea THX Hi Dennis, Do you have any way to export sql table to excel sheet without using any programming language. Regards, Fred ...Show All

• Visual Basic C# typeof -> VB equivalent?

  I got a library written in C# that has a class that exposes a method similar to this: class Test { ... public void DoSomething(object value, Type type) { ... } ... } If I would call it in C#, I would e.g. call: new Test().DoSomething(myValue, typeof(string)); What is the equivalent of the "typeof(string)" expression in VB I googled and found a lot about some VB syntax to compare types with "Typeof something is SomeType", but what is the VB keyword for getting the Type (class instance) from a type keyword like 'String' No, that is not what I was looking for, what you are writing there would be the equivalent of if (this.TextBox1 is TextBox) { ... } what I was looking f ...Show All

• Windows Live Developer Forums GeoRSS and Static point

  I have a number of GeoRRS Layers that I am using to display various pushpins.  I would like to also show one point on the map at all times.  Here is what I am trying to do but something is not working right: //Start of Script..............................    <script src=" http://dev.virtualearth.net/mapcontrol/v3/mapcontrol.js"></script >        <script> var myMap; var tileLayer; var tileSourceSpec; function onPageLoad() {  myMap = new VEMap('map1');  myMap.LoadMap(new VELatLong(45.45303010460688, -122.7883368730545), 17 ,'h' , false); }          function AddPin()       & ...Show All

• Visual Studio Team System Intergrating Bug List into inhouse HelpDesk

  Hi All I'm trying to intergrate the Bug/Task list from TFS into our homebuilt HelpDesk system. Problem I've got is that our HelpDesk is not written in a .net system and as such does not have access to the intergration services. Is there a way to simply access the bug/task list for our project via a normal SQL query have done a bit of looking around the databases on our TFS but can't find any tables that look like they hold the data. Any help would be seriously appreciated Kind Regards Lee But surely - if the data is held within a database then in theory I should be able to query the database to find the data that I want - officially or not! While the tracking system within the TFS system is ok for the de ...Show All

• Silverlight (formerly WPF/E) Squeezing objects

  I was wondering whether it is supported to "squeeze/distort" objects into various affine and skeewed forms Basically what I wan't to do is squeeze an image (or any other object for that matter) into the following shape: ___________ / \ / \ / \ / \ / \ I would also need a variant the would require adding some skewing like this: ___________ / | / | / | / | / | or ______________ / / / / / / / / / / ...or anywhere in between these. (and no, I'm not talking about clipping :-) Any ideas on how to accomplish this are very welcomed! Thank you very m ...Show All

• Smart Device Development System.data.sqlclient assembly reference not found

  Hi there I'm fairly new to application developing for pocket pc though I have some experience in vb.net with visual studio 2005. I've started with a very simple project to start with. I have a form with a data grid attached to a database in a remote server. The data set is filled when the form loads and that's it. My problem is that when I deploy the project to the device, an exception occurs saying "name of file or assembly 'system.data.sqlclient, version=3.0.3600.0, culture=neutral, publickeytoken=3BE235DF1C8D2AD3' not found". It doesn't appear to getting to run at all. I've been googling a lot and searching these forums and found some related issues but never the same, and none of the solutions apparently could work f ...Show All

• Windows Forms Composite Control

  I want to build Composite control using Datagrid in .NET 2.0 that should be reffered in ToolBox of VS2005. can any body suggest me some useful links regarding this problem and which project type should i choose for doing this. ...Show All

• Visual Studio Team System Version 2.0.50727.145 - Large schema import, then compare, too many diffs

  I am using: Microsoft Visual Studio Team Edition for Database Professionals Version 2.0.50727.145 1) A large schema was imported [ one unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.VisualStudio.TeamSystem.Data.Schema.Interpreter.InterpretUpdateTextStatement(TSqlFragment fragment, ISchemaAnalyzer analyzer, List`1 path) at Microsoft.VisualStudio.TeamSystem.Data.Schema.Interpreter.CallSubInterpreter(InterpreterDelegate interpretationMethod, TSqlFragment fragment, ISchemaAnalyzer analyzer, TSqlFragment parentFragment, List`1 path) at Microsoft.VisualStudio.TeamSystem.Data.Schema.Interpreter.InterpretBeginEndBlockStatement(TSqlFragment beginEndBlockStatement, ISchema ...Show All

• Visual C# Why doesn't my code work?

  I want my tabs to always be 1/4 (there are 4 tabs) the width of the tab container, but when I do the following code: Size temp=tabs_main.ItemSize; temp.Width=tabs_main.Size.Width/4; But it doesn't work, nothing happens at all. Yes, SizeMode is set to fixed. ~DtD PS. The code is in the Resize event for the tab parent, I also tried it in a press button event. DtD, the problem seems to be due to the fact that you are resizing the tabs in the Resize event of the TabControl itself. Changing ItemSize fires off another Resize event, and this produces an infinite loop that locks up your app and is probably the source of the exception you saw (even though I didn't manage to ...Show All

• SQL Server Remote connection not working using MSSMSE

  Im getting quite desperate and frustrated!! I have installed SQL 2005 Express successfully and can connect to it fine using Management Studio locally. If I try and connect remotely using Management Studio Im getting the old Error 10061 : The machine actively refused the connection! I have set it up exactly as per all documentation and help from the forums. Remote connections is on TCP and Named Pipes, I even have the firewall disabled. Im running it on Windows Server 2003 Standard. Any help would be really apriciated as i have tried everything!!! Xinwei: I can successfully telnet to port 1833 remotely. In the configuration manager > SQL Native Client Configuration > Aliases - there is ...Show All

• SQL Server Encryption in SSIS Package

  Hello, I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function. JatinShah wrote: Hello, I want to import data from a excel source to SQL Server 2005 using SSIS. Among all the calls columns to be imported, there is 1 column which needs to be encrypted using asymmetric encryption and stored in destination table. Can anybody guide me how to program SSIS package using encryption function. I think Donald Farmer's book contains some information on how to do this. You'll be ab ...Show All

• Visual Studio Team System Performance Tool crashing when it interprets VSP

  Hello, The performance tool (profiler) worked great for one of our apps. I was able to focus on some problem areas, and we spotted some things we didn't expect--very helpful. However, I'm trying to use it with a 2nd app and having problems. When I close the app, I see that it starts to interpret the VSP file but then it fries...it crashes, closes down visual studio entirely, and restarts. Has anyone seen something like this and do you have suggestions Oh, and I'm using "sampling." I'm attaching to the app after it starts because I had some problems "launching." Thanks! Hello Ian, Actually, late Friday, I tried the profiler when I was using a different database under t ...Show All

• .NET Development Sending mails on a localhost IIS SMTP Server

  Hi, I wrote a code to send mail and I want to test on my IIS server. I tried to set up my IIS SMTP server then I used Outlook to check my email but I had an exception Your server has unexpectedly terminated the connection. Possible causes for this include server problems, network problems, or a long period of inactivity. Account: 'localhost', Server: 'localhost', Protocol: POP3, Port: 110, Secure(SSL): No, Error Number: 0x800CCC0F is there any tutorial for setting up IIS and Outlook to send and receive mails on the localhost server I saw in many WebCasts doing it but they didnt show how to set up the servers. Thanks in advance. From the sounds of it you do not have a POP3 ...Show All

• Visual Studio 2008 (Pre-release) Where are the BitmapEffects?

  A while back I read that there were 48 different BitmapEffects in development for v1... As of RC1, it doesn't appear that any more have been added. Are these 48 still planned for v1 Even better, is there a list of BitmapEffects in development somewhere I've scoured the web with no results. Thanks, F. Thanks Drew, my suspicion was that they have been cut, given the silence on the subject. I'd still like to get an official response from someone on the WPF team - can anyone comment Thanks, Fred. ...Show All