forrestcupp's Q&A profile

• SQL Server Slowly Changing Dimension Type 2

  Hi, I'm a newbie to the SSIS 2005. I'm trying to update a dimension table using slowly changing dimension transformation, where I want it to insert new rows if it's not already exist in the dimension table, or if it already exists with some data changes, it'll then update the original row's expiry timestamp being the current time, and inserts a new record in the dimension table. But now, it always inserts new records to the dimension table, although the row already exist with no data changes. Why is this the case Am I missing some configurations here Thanks a lot for any help! Chengg ...Show All

• Visual Studio Team System Administrator gets 403 - access denied

  Hi, When I log in as admin on my Team foundation Server, I can no longer connect to the server through Team Explorer. I get the following message: TF31001: Team foundation cannot retrieve the list of team projects..... ....The request failed with HTTP Status 403: Forbidden. I also get a 403 when I try access the web services through internet explorer. http://localhost:8080/services/v1.0/registration.asmx gives me a 403 as well. Now I know this is my own doing because I was previously able to acces these services using this login. It all went pear-shaped when I started fiddling permissions, trying to get a new user access to TFS. Eventually I got the user working, but Admin stopped working! I played with file system permissio ...Show All

• Visual Studio Team System Looking for a good online book to convince my manager

  Is there somebody how can give me a PDF version of the following book: 'Working with Microsoft Visual Studio 200 Team System' written by Richard Hundhausen. Part of our company is already using Microsoft Team Foundation. We want to introduce this in other departments as well. Once I stumbled on a PDF version of the book mentioned above. I printed the document but forgot to download it. I want to make this document (or a similar book) acceccible via our intranet so others can have a look at it. According to some information I found I should be able to get this document for free via my MSDN license but I cannot find it anywhere. Thanks, Arjan I don't think it is a good idea buy or download bo ...Show All

• SQL Server ETL Guidance

  Hi, We've decided to use SSIS for an ETL type project. We are going to convert some files to our special flat file format. Our special flat file format will not change, but we will need to convert about 40 different style flat files into this format. We will receive any of these files at random intervals. We will likely have to add more file formats to the 40 at some point, too. I'd like to use a flexible design, but I just started with SSIS and its going to be hard to test all the possible combinations, so I hope I can find some guidance in this forum. What would be a good approach to allow for the most reuse of work to support these various file formats At worst you'll need to make a c ...Show All

• Visual Studio Team System Data not inserted into Web application dB on parameterizing

  I am testing a JAVA web application. when I am recording an insert action, the data is inserted into the Database. When I parameterize that same web test and run it with the setting "ONE RUN PER DATA SOURCE", the test is runing for 'n' number of times. But, the corresponding Data is not inserted into Database. Please let me know where I am going wrong..... Hi, so the first thing I would do, is trace the database. I would create a simple load test that will run for couple of minutes. You can set the test to trace a database and a table. Once the test has completed you will be able to see what queries were executed against that table. Maybe then you will have more understanding and you will be able to se ...Show All

• Visual Studio Organizing additional content

  Asside from interrupting the processing and using a external script or executable, how does one go about organizing additional content within the help file Thanks! Rory The order of the additional content items in the list determines their order in the table of content. You can use the Up and Down buttons to rearrange the items. Only items with a content description count. Folder items and those without a content description are ignored regardless of their position in the list. Currently, only single file items can appear in the table of content. I've got an item on my To Do list to see if I can support hierarchical content so that you can create sub-folders within the table of content. Eric ...Show All

• Visual Basic How to load a child form within MDI form's panel

  Hi, I a newbie here. Does anyone know the coding regarding my question Pls HELP........................ i think you want to show the form in a particular position in the mdi parent. then just set the form's height and width property and the location property accordingly you want to dispaly. If you want to display the child form like the windows status bar. where all the application are shown as a rectangular box and clicking on it open the form. then take a status bar and when the form is loaded you load the panel on the status bar showing the name of the child form and show hide the form when the panel is clicked. ...Show All

• Commerce Server Product Sorting

  I'm working on Browse.aspx from the starter site and I want to implement sorting functionality based on the column header in the GridView. I know the productList control uses the ProductFilterDataSource control to get it's data and ProductFilterDataSource inherits from CatalogDataSource. I think I've done everything correctly, but the error I keep getting is " The data source does not support sorting. " Anyone have any ideas or guidelines I should be following to get this working Thanks, Brad Hi Joe, Thanks for the input. I had gotten that far and was attempting to handle the onsorting event to get bi-directional sorting working. That's actually when I got the error I originally posted about. I' ...Show All

• Visual Studio Team System Enhancements request on the Attachements feature

  Hello, It would be nice to add the following functionality for attachements in work items: - Add these 2 columns to the attachement table: Size and Creation Date - Add a "save as..." menu to the contextual menu appearing when you right-click and attached file to be able to save the selected attachement on the disk instead of opening it. Thanks, Gaetano. We have heard the "save as" request many times and will consider it for future release. For now, our powertoys can be used to save attachments, and I'll soon post an addin to do it in my blog. I'll note the "creation date" feature request. BTW, You can directly raise bugs or feature requests at: https://connect.mic ...Show All

• Visual Studio Express Editions Microsoft's Web-based registration fails for VS 2005 Express

  September 7, 2006 Visual Studio 2005 Express only runs 30 days without registration. Registration page fails to login with an existing Passport account. Registration page fails to login with a newly created Windows Live account. Registration information page provides no option to register. The error message from the Microsoft registration page reads: "The Microsoft Passport Network is unavailable from the site...." We are running only valid, registered Microsoft software on a nearly new computer under Windows XP Pro SP2, with all upgrades. We have no known problem with any other software or Web site. Registration page entered from Visual Studio 2005 Express -- https://login.live.com/ppsecure/secure.srf lc=1033&id= ...Show All

• Windows Forms Storing custom class in Application Settings

  I would like to store a class defined by me in the "windows from application settings". This is not easy to do, but it seems to work, mostly: 1) Open Settings.settings with the Settings Designer. Because the dropdown list doesn't allow me to chose my own class, I just use a property of type string. Close the Settings Designer and save the changes. 2) Open Settings.settings with a text editor. Change the type to my class. save the change. 3) Open Settings.settings with the Settings Designer. A property wiht my the type of my class is displayed. Nice :-) From my code, I can create a new instance of my class and assign it to the application settings, save them and read them again. This works for all fields in my class wh ...Show All

• SQL Server Read Write Image data with Sqlceserver

  I was wondering if it is possible to read image data from a database in .net compact framework. Since cf does not have image.fromstream(memstream) to work with, I don't know how else to read the image from the database and then place it into a picturebox. Here is the code I have been trying out: Dim Img As Image ' Dim conn As New SqlCeConnection("Data Source = \My Documents\test2.sdf") conn.Open() Dim sql As String = "SELECT * FROM Dater" Dim cmd As New SqlCeCommand(sql, conn) Dim reader As SqlCeDataReader = _ cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection) While reader.Read() TextBox1.Text = reader.Item("name") Dim b(reader.GetBytes ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GSE RTM on Vista RTM (unsupported)

  i know it's not supported ... but has anybody got it to work bought the club account on the 360 and downloaded the app on the 360. installed Express on Vista with no problems and registered. tried an update, but didn't see any service packs. then i installed GSE, which complained about the VS projects, but it still seemed to install. fired up Express and the XBox 360 Starter kit project was there and built fine. went to tools options, and setup the connection to the 360. then i set the 360 to listening mode. but when i try to deploy, it just comes back and says make sure the the 360 is listening. also, turned off the vista firewall but got the same results. any ideas Thanks, casey Dave, ...Show All

• SQL Server Cast from string to date

  I created an SSIS package that pulls in legacy data from a DB2 AS400. There is an In Date field that is stored on the AS400 as OdbcType.Date or DATE. However, when I use SSIS to pull in the data, SQL wants it to be a string so I gave up and let SQL have it's way. Now in my SELECT statement, I have this: SELECT TLMST.TLNUMBER, TLMST.DOGNAM, BRDMST.BRDesc, TLMST.INDT FROM TLMST INNER JOIN BRDMST ON TLMST.BRDCOD = BRDMST.BreedNumber WHERE (TLMST.INDT >= @startdate) AND (TLMST.INDT <= @enddate) ORDER BY TLMST.INDT, TLMST.TLNUMBER Because I see the dates stored in TLMST are yyyy-mm-dd format, this is not working. It is not pulling any records. I tried to use the CAST statement but I keep getting errors about c ...Show All

• SQL Server 1-Many Join dlimena

  Hi people, I am trying to create a view based on 2 tables. A header and a detail table. However, in the header table is a couple of fields that I only want ot appear once for each header record. For example, Budget and Area which are columns in the Header table should only appear for the first joined record not in every row for that column. If I just do a normal join then I get this appearing in every row. I know I can use Distinct Agg functions to eliminate calculations later but there is an issue with SQL reporting serives that has major limitations. This is the ideal scenario. How is this achieved with T-SQL JH.JOB JH.BUDGET JH.AREA JD.AMOUNT JD Description would give 123 $2300 254 $3000 Toilet rolls 123 $2300 254 $3200 C ...Show All