almpirat's Q&A profile

• SQL Server Compare Data Before Inserting

  I have a DTS package in which I would like to move to SSIS and also add some new functionality.  My current DTS package is pretty simple: 1.  Download a flat file from an FTP site 2.  Execute a SQL task that deletes the data from the table 3.  Insert the data into the table. With SSIS I would like to first compare the data in the flat file with the data I already have stored in the table.  If the data is new, then insert the new row into a different table.  Can this be done via SSIS Yes this can be done in SSIS, but the real questions are what identifies the data as "new" ...Show All

• Visual Studio Express Editions Adding items to ListView, but wont show up under the first column.

  I was trying to add some subitems to a listview, but they will never show up under the first column, only starting with the second. I'm using the ListView.SubItems.Add("string") method. Isn't that what SubItems.Add is supposed to do. The "Item" goes in the first column and sub items go in subsequent columns. Dave ...Show All

• SQL Server Populating Dimension Tables

  Let's pretend I'm building a web stats warehouse, and I put referer strings in a dimension table like so: CREATE TABLE Referers (   RefererID int IDENTITY NOT NULL,   Referer varchar(2048) NOT NULL ) My data source is an XML file of web requests.  It looks like I need to write the data flow like: 1. Read stats file using XML Source task 2. Use an Aggregate task to group on the Referer string 3. Use a Lookup task to find the RefererID values for referers that exist 4. Use a Conditional Split task to grab only the records where ISNULL(RefererID) is true 5. Use an OLEDB destination task to insert the new referers into the table A ...Show All

• Windows Forms vb express and sql server express

  Hi, I am trying to use the combo "vb express and sql server express" to know in advance what these two products will be like; I haven’t done anything yet because I am unable to create a Data Source. When I open the New Data Source wizard and try to create a Data Source, I always get these error:  An error occurred while retrie ...Show All

• Windows Forms Control sizes shink after opened from saved xml for .net 2003

  I just installed .net 2003.  My project saves the designed forms into xml files, and opens the saved xml files back to form designs.  The problem is that everytime I open the saved xml file, the size of the controls gets smaller.  However, the saved size property is right, it only changes when I load it back to designs.   It did not behave like this in my old system.  I just changed the system to new computer, new monitor, and new visual studio .net 2003.  Thanks for any suggestions. I found out that it has something to do with the AutoScaleBaseSize property of th ...Show All

• Smart Device Development Pocket PC connection!

  Dear MSDN support, When i am deploying the emulator and running the following URL in the emulator to check if i have access to a publication i got an error telling me that i could not connect because i have no connection, but i have just setup a proxy setting on the emulator because i only connect to the internet through a gateway! http://my_computer_name or the ip_address/publication_name i.e. the same as the database/sscesa20.dll Posting this thread in the Emulator forum at - http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=76&SiteID=1 ...Show All

• System Center RAM in servers?

  In the hardware editor I can specify the type and number of processors, the type and number of hard disks as well as the use of RAID sets. What about RAM RAM recommendations are only provided by the Model Wizard. These recommendations are determined by a high level heuristic based on best practices. RAM recommendations are not updated as a result of changes made in the Model Editor. Therefore, memory is not included in the Hardware Editor. ...Show All

• Visual Studio Check in web service that are already under source control for VS2003

  At this moment we are upgrading web services, that are already under source control, from VS2003 to VS2005. The upgrade is successful, but when we want to check these web services in VS2005 is complaining that the *.asmx is already under source control and stops with check in of the other files. For a web service we checked the other files in with our source control manager and reopened the project. VS2005 do not notice that these files (app_code\*.cs) are under source control. Does anybody know what the problem is thanx in advance How did you migrated your VS2003 web project To a (folder-based) website o ...Show All

• Visual Studio Team System How do I turn on logging for Version Control?

  In Beta 2 I added a <add key=”commandLogging” value=”Normal” /> to the web.config under the appsettings.  However, I tried adding this to the Beta 3 web.config and received an error within Visual Studio. How can I turn on logging in Beta 3   No log data is currently being created in the DB. Thanks, ~slee Try it using notepad.  I believe that you still add that to the AppSettings section in the top web.config (sits in the Web Services folder). For those looking for more info, see Jeff Lucovsky's posts on it.  Note that the database is now called TfsActivityLogging. http://blogs ...Show All

• Visual FoxPro Changing screen resolution with FoxPro

  So, after I did not find any solution of my DirectX problem, I'd like to ask how can I change the screen resolution via FoxPro. MFC, API calls Thanks Sorry I don't have an answer to your DirectX question as I'm not a graphics designer so I have no experience with DirectX. Maybe you can get you are looking for with VFP9 and GDI+. As per your current question: Robbo's function is also documented in "using Win32 functions in VFP": http://www.news2news.com/vfp/index.php search=ChangeDisplaySettings But it is important to consider that changing windows screen resolution on the fly is not a good move. Not on ...Show All

• Visual Studio Express Editions List of computers (VB2005)

  Can you help me to find a method to discover the list of computers from my workgroup and i put the name of computers in to a listbox Thanks You can use the netserverenum api to list the computers Imports System.Runtime.InteropServices Public Class Form1     <DllImport("netapi32.dll", EntryPoint:="NetServerEnum")> _     Public Shared Function NetServerEnum( _         <MarshalAs(UnmanagedType.LPWStr)> ByVal ServerName As String , _         ByVal level As Integer , _         <Ou ...Show All

• Windows Forms DataGridView and ComboBox Column Problem

  i develop with VB.NET 2005. i am using DataGridView, and i have a column its type property ComboBox and my problem is that i want to fill the combobox in each row of this CombBox Columns with different items. when i fill the CombBox in a row all other ComboBox in the other rows are filled also, but i want to fill every row CombBox seperatly. i want to deal with each row combox alone. I hope u understanded the problem. Thanks By default all items in all rows are shared, to save memory. In a large table, having a separate set of items uses quite a bit of memory. You should be able to unshare the items collections by ...Show All

• SQL Server Help using a value from one dataset to lookup a value from a second dataset

  Hi All, I'm quite new to SSRS (and .net development as well) so any help would be useful. My problem is this: I'm running a report from a Sybase ASE datasource to pull data into a table control. One of the fields I'm pulling in is called assignment group. Now, in the same report output I also need to display who the manager of that group is... unfortunately this information is not stored in the same database. We store the manager information in a completely seperate Oracle database. So, I need some method of 'linking' the data from my Sybase dataset to a table in Oracle and I can't quite figure out how to go about it. Every record would h ...Show All

• .NET Development Value of first parameter to Stored proc always goes as a blank.

  Hi, In C#, Iam using ADO to access data from SQL server 2000 through stored procedures. When ever I try to pass a value to input parameter, the first parameter always goes in as blank value, even though the value for this parameter exists in the parameters collection of the command object. Thanks in advance. I can assure you, there is no ghost monkey in your code eating up your parameter value. If it's setup properly it will show up at the database end. Here is what I'd look for a) ParameterName being correct b) parameter direction being correct c) parameter data type being correct d) parameter ...Show All

• Visual Studio Team System Cannot connect VS 2005 Team Suite client to Team Foundation Server

  I have installed Team Foundation Server Beta 2 (application and data tier on a single server) and the install seemed to work correctly. I can certainly use the Sharepoint Services pages successfully. I have Team Suite Beta 2 on a separate machine and I am attempting to connect to the TF Server. However, when I use Tools/Connect to Team Foundatioin Server and add the server I get a message saying "Unable to connect to the Team Foundation Server:vstfs [...] Url: http://vstfs:8080 ". vstfs is teh machine name and I can ping it or even open a browser session to view the Sharepoint pages. If I try http://vstfs:8080 in the browser I get a 403 (not ...Show All