el_co's Q&A profile

• Visual Studio Team System The application for project is not installed (project types .rptproj and .dwproj)

  It used to work, but then... Visual Studio 2005 was hummin' and I had a number of BI projects in both Report Services and Analysis Services. I wanted to add source control and decided to install the Team Suite and I did something wrong. I just don't know what it was. In the end, I deinstalled every Visual Studio 2005 (including, of course,the Team stuff)and SQL Server 2005 application, and reinstalled old faithful Visual Studio 2005, but nothing has worked. I'm missing the Business Intelligence project templates completely and I'm guessing that if I had them, I wouldn't get either of the following 2 messages when I try to open existing projects: "The project application for 'c:\...\SOS.dwproj' is not installed. Make sure the ...Show All

• SQL Server ssis developers

  where can i find pay rates or salaries for ssis developers thanks in advance. yosonu wrote: My company is working with an SSIS consultant and we are paying him $300/hour. in which city ...Show All

• Visual Basic Selection of item in dropdown not revealing subsequent dropdowns in webbrowser

  Hi there, I'm sure this is a really dumb question but I'm new to webpages etc... I'm trying to fill in data on an online form which when first loaded contains nothing but one dropdown box. When a value is manually selected in that dropdown in the webbrowser, it reveals a second dropdown box. However, when I set the value of the first dropdown programatically (webbrowser1.document.all("ID").value=x) the second box does not appear. I have tried the Invokemember("submit") solution posted elsewhere in this forum, but it does not work as that method is not supported by the "ID" element. Any help would be greatly appreciated as I've just about pulled all my heair out :) Thanks in advance ...Show All

• Windows Live Developer Forums Getting the Direction between 2 points.

  Hi all, Let me see if i can make you understand what i need to do. I have two points (like latlong points), and i want to know if X is set 'north ou south, east or west' from the Y point. Please if you know, tell me how to do that. And also please tell me if you don't understand what i mean. Thanks Ton Somebody can correct me if I'm wrong but if you just compare the lat/longs you can get this information. If lat1 is less than lat2 then point 2 is East of point 1 If long1 is less than long2 then point 2 is North of point 2 There's probably an easier calculation...something like (lat2 - lat1) / (long2 - long1) = slope Then use the slope to tell you the direction but it's been 11 years since I had Geometry. I'll l ...Show All

• Visual C# What is with all of the files for a simple program?

  I posted this in the IDE section but got no reply so I am trying it here. I am just learning C# and made a solution for a command line program. I would like to know what the heck all of these output files are for and can I somehow force them not to make subdirectories. I was able to remove the bin directory but not the obj\Debug etc. directory. Also don't understand the Test.vshost.exe file and the duplicated Test.exe and Test.pdb files. \---Test | Test.sln | \---Test | Program.cs - Main Program | Test.csproj - Project | +---bin | \---Debug | Test.exe - Executable | Test.pdb - program database for debugging | Test.vshost.exe - WHAT IS THIS FOR | +---obj | | Test. ...Show All

• .NET Development Errors using the UploadFile method

  I'm attempting to write a .NET 2.0 web service to upload a file using a specific user ID and Password. I would like to avoid using the ASPNET machine account for security issues. Here is my exact code snipet: My.Computer.Network.UploadFile("C:\sample.log", " http://localhost:3477/wsFileUpload/Uploads ", "testuser", "testuser11") I'm receiving the following WebException error: The remote server returned an error: (405) Method Not Allowed Further error trapping reveals: Status=ProtocolError Sometimes I am receiving: The underlying connection was closed: An unexpected error occurred on a receive. Status=ReceiveFailure I am attempting to run this on my local PC. VWD 2005 Express created a \WebSi ...Show All

• SQL Server whilst stuck in a land of 6.5 compatibility

  is there an alternative to a user-defined function, short of an extended stored procedure How does scalar UDFs figure into the whole filtering process Why do you even need scalar UDFs when it is a performance hog especially when used in queries There is nothing analogous to scalar UDfs in 65 mode. You simply cannot use UDFs and that is the way the compatibility level works by allowing old code to run as is or with minimal changes. So certain new keywords, statements etc will not work. Your best bet is to ask the vendor for 65 compatible code. Alternatively, you can create a proxy database in 80/90 mode that has views pointing to all of the tables & views in the 65 compatible db and create the vendor c ...Show All

• SQL Server I receive MSG 7707 when trying to split a partition for the second time. Why ?

  Hi I am trying to implement a sliding window on a table in SQL Server 2005 but i am having some problem. I have two tables, "Letture" and "LettureStorico". The first one receives data on a few seconds basis, some thousands of rows each day. The second is the historical record and should store all the records till midnigh of two days before, that is, if today is November 21st, LettureStorico stores rows till November 19th 23.59:59.997. At some time during morning of each day i want to run a stored procedures that takes the records older than midnight of two days before in "Letture" and switch them as a partition in "LettureStorico" Here's what i do: /*-------------------------------------- ...Show All

• Visual Basic How to create a dockable ToolBar type App. with Auto-Hide etc.

  Hi, Anyone know of an online tutorial to create a dockable toolbar type application please    Application to also have: 1) Always On Top option. 2) Is registered in the ToolBars dialog when you select the Windows TaskBar "ToolBars" option. 3) Has an Auto-Hide option. 4) Has a LOCK option. 5) The dockable option needs to dock with any side, top or bottom of the windows GUI in the same way the TASKBAR can be at the top, bottom or either side.   A short simple example would be ideal please.  I know it's a lot to ask, sorry .   Regards, S_DS   Hi http://msdn.microsoft.com/library/default.asp url=/library/en-us/shellcc/platform/shell/programmersgu ...Show All

• Visual Studio Express Editions code not associated with a button

  I need to have code that collectes UDP frames from another computer (port 1234). I found some examples but the code is not part of a button. I have yet to find anything telling me how to add code that is not associated with a button. The code example is here: http://www.codeproject.com/vb/net/Silence_Socket.asp But it does not tell me where in the project/solution to put it. What window do I open and how do I open it How or what starts running the code Thanks for your time My understanding is that you want the code to be excuted at startup. If that is the case, you can place the code in the forms load event. Just double click on the form and copy/paste your code in Form_load event. VB is event driven which means yo ...Show All

• SQL Server Strange Query Behaviour

  Hi, I am seeming strange results with a query. I have two tables, lets call them Table1 and Table2. Table1 has an ID field, Table2 does not have an ID field. To be sure I wasn't blind, the query 'SELECT ID FROM Table2' returns: Invalid column name 'ID'. OK. Now when I run the query 'SELECT * FROM Table1 WHERE ID IN (SELECT ID FROM Table2)' it returns all the records from Table1. What gives Is this a bug, or am I missing something I didn't find any Strange result here.. You are using Sub Query, here column ID is fetched from the Table1 not from Table2. Try this, Select 100 From Table2 What you got 100 will be return on all the rows Rite. But 100 is not depend with your T ...Show All

• Software Development for Windows Vista XPS to GDI print path

    Hi  i want to use XPS to GDI conversion path for GDI based printer. From MSDN i came to know that The XPSDrv model also provides a converter for XPS to GDI format so that Win32 applications can print XPS Documents.  How can i use this XPS to GDI conversion path .  Is there any way to get a postscript as an output from an XPS printer  Driver .     Regards Abhishek Why not just print your xps-file on the postscript-printer like... // get a PrinterServer LocalPrintServer ps = new LocalPrintServer(); // get your PrintQueue to desired Printer PrintQueue pq = ps.GetPrintQueue("HP Laserjet 5Si"); // get a XpsDocumentWriter for the PrintQue ...Show All

• SQL Server SSIS Performance 32 Bit V 64 Bit

  I have been working on a project last few months. I have developed the project on my laptop, which is resonably powerful. It runs through fine within 9 mins with sample data set. If I replicate the same environment on a 64 Bit machine with 32 Bit Win 2003 and SP1, it takes just over 7 mins. If I rerun it on a 64 Bit machine with 64 Bit Win 2003, it takes between 21 and 24 mins. We are executing the packages via dtexec on a command prompt. Has anyone seen same behaviour Thanks Sutha > If I rerun it on a 64 Bit machine with 64 Bit Win 2003, it takes between 21 and 24 mins. Try running it on same machine under 64-bit Windows, once using 64-bit dtexec.exe from "C:\Pr ...Show All

• SQL Server Foreach endless loop

  I'm having a problem where I'm using a Execute SQL Task to retrieve a dataset and storing that in an object variable. Then on success of that execute sql task I use a foreach loop task to go through the dataset and do 2 tasks inside the foreach loop. When I execute this package I have ~12 records in the dataset however when I get to the foreach loop in the 2nd iteration it keeps repeating it. It acts like it is stuck on the second record (tuple) and never goes on. I'm using an ForEach ADO Enumerator in the foreach. I've even set a breakpoint on each iteration and no task fails in side the foreach loop. I'm completely perplexed why it will iterate to the 2nd record but get stuck there in an endless loop. I've tried this on 2 different compu ...Show All

• SQL Server MAJOR PROBLEM: New SQL2005 installation performance problem.

  We are experiencing a major issue since upgrading from SQL2000 to SQL2005 over the weekend. Starting today, it appears that the performance of SQLServer reaches a limit every 15 minutes. Our configuration is as follows: Window Server 2K3 x64 Enterprise SQLServer 2005 x64 Enterprise HP DL585 with 4 dual core Opterons 32 GB of RAM 2 TB EMC SAN At first, I thought there was a memory pressure problem, since I had the default max memory set. After changing the max memory to only 25 GB (out of 32 available), the issue went away temporarily. However, after 15-20 minutes, the number of batches/sec dropped in half, and remained after half until I changed the max memory setting again. Over the course of the day, I was able to fi ...Show All