Laura Busuioc's Q&A profile
SQL Server Insert /Update data in destination
I am new to integration services. I am trying to a build a data warehouse and need to be able to insert new data as well as update data that has changed. I am getting the data in a flat file and need to import it into SQL 2005. I saw some post on www.sqlis.com/default.aspx 311 but I did the example is for OLE DB component. I am not sure how to achieve this using a text file as source. Any help would be greatly appreicated. I'm assuming your trying to populate/alter your dimensions. In that case, the SCD transform will be a very good start. You build your source from the flat file and then in the SCD w ...Show All
Visual Studio Team System How to change the default checkin action in Pending changes window
In the pending changes window you can associate an workitem with the checkin. Is it possible to change the actions here At least I want to change the default value from resolved to Associate.. Thanks for any help borg3000 Please see thread http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=200898&SiteID=1 ...Show All
Windows Forms Change the checked and unchecked value of a DataGridViewCheckBoxColumn
Hi, What I'm trying to do is quite simple..... 1. I've created a empty DataGridView 2. I add a DataGridViewCheckBoxColumn using the following code- colToBeAdded = New DataGridViewCheckBoxColumn colToBeAdded.FalseValue = 2 colToBeAdded.TrueValue = 1 colToBeAdded.ThreeState = False colToBeAdded.valuetype = GetType ( Integer ) colToBeAdded.HeaderText = headerText colToBeAdded.Name = colName colToBeAdded.DataPropertyName = colName dgItemSelect.Columns.Add(colToBeAdded) 3. I then bind my datatable to the datagrid view:- dgItemSelect.DataSource = dt The datatable contains a column of type integer ...Show All
Visual Studio 2008 (Pre-release) Canvas Performance
I have an ItemsControl bound to 500 items. As Panel I use a Canvas (each item has a coordinates and size where it should be positioned). As DataTemplate for Items I have Button containing a StackPanel with some TextBlocks. When I'm trying to show this, it takes about 5-10 seconds. Is this normal How can I speed it up Can you elaborate further It'd help if you could post your code, or at least pseudo-code, since the description of what you're doing is too vague. David ...Show All
.NET Development Message queues: public vs private
I'm writing an app that will be using message queues to talk to a remote server. My only question is, which type of message queue should I be using: public or private From what I've seen, the only difference between the 2 is that public queues provide routing and use Active Directory, whereas private queues don't. (And of course the different way of referring to the queues by name, but that's minor.) Please help; I'm a .NET newbie (only been using it for 3 weeks!) and the answer to this question is vital to the app that I'm building. I can type a long anwser about why using private, or why using public. But Chris Preston posted a real ...Show All
Visual Studio Express Editions Problems with Downloading Registration Benefits
There have been several reports of problems with accessing and downloading registration benefits. We have investigated the issue and have news to report. This sticky thread will be updated with additional information as it becomes available over the next few days. Background In order to negotiate deals with partners and authors to provide the highest value benefits, we must must be able to guarantee a secure download center that limits benefits distribution to those who have registered. We use the Microsoft Connect site to provide our secure download infrastructure, which is why you are redirected to the Connect site from ...Show All
.NET Development CommandText in SQLClient Command Sintax
Hi, I'm upgrading from ADO to ADO.Net. I used in ADO the following: AdoBdp.Execute "Update Database.dbo.Table Set Field=blabla... where blabla..." Weere AdoBdp was the connection object. Works fine In ADO.Net i tried: Dim loCmd As New SqlClient.SqlCommand loCmd.Connection = AdoBdpNet (SqlClient connection - working fine) loCmd. CommandText = "Update Database.dbo.Table Set Field=blabla.. where blabla..." loCmd.ExecuteNonQuery() I get the error: {"Could not locate entry in sysdatabases for database 'Update Database. No entry found with that name. Make sure that the name is enter ...Show All
Windows Forms Mitch- next version?
It's has been 7 months since it was mentioned that the next version would be released "soon". Has this been pushed back It seems like the longer this goes on, the more difficult it is going to be to get people involved in this again. I meant Tech-Ed San Diego. :) It is approaching release, there are a couple&n ...Show All
SQL Server Answer SQL Server 2000 DTS Tools Web Download
Is the Web Download to install SQL Server 2000 DTS tools available yet If so where Thanks Darren Sometimes happen the same and even only appears the arrows. I had a lot of problems with this messing up my Sql2k Entreprise Manager. ...Show All
Windows Forms Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib
Hi All..... I'm getting a security Exception in a Winforms User Control embedded within a web page using the <OBJECT> tag. It reads as:- Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed. This is not a beginners problem.... I'm fully aware of Code Access security and have  ...Show All
Visual Studio Tools for Office How to use OWC11 component in ASP page
I know how to use owc9 in the ASP page and how to use OWC11 in the APS.NET page, but i don't know how to use the OWC11 in ASP page. who can provide some examples to me thanks. I've reposted your question to the Office Web Components news group as it is non-VSTO related and out of our domain knowledge. http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.web.components Thanks Darryn Lavery [MSFT] ...Show All
Smart Device Development Using RTC api in .net compact framework
Hi, I want develop a application based on RTC api for pocket PC but the RTC api cannot used in .net compact framework directly as it is a COM based object model. So how can I develop a application in C# that makes use of RTC api. Thanks Honey Patodia As for any other COM interop, your options are: - Write a native wrapper which would expose flat C functions you can P/Invoke. - Use 3rd party COM interop (e.g. CFCOM). - Use NETCF V2 which has COM interop. ...Show All
Visual Studio Express Editions VSContentInstaller.exe - Bad Inmage
After reinstalling XP Pro and then installing VS 2005 Standard, I decided to try a starter kit. I downloaded the Amazon Movie one and clicked on the file and got this Alert message: _____________________________________________________________________ .NET-BroadcastEventWindow.2.0.0.0.33c0d9d.0: VSContentInstaller.exe - Bad Inmage The application or DLL C : Documents and Settings\Dilbert\Desktop\AmazonMovieCollection_1_0_vb_rtm.vsi is not a valid Windows image. Please check this against your installation diskette. --------------------------------------------------------------------------------------------- Has anyone else had thi ...Show All
SQL Server Flat File Source, please Help !!
Hi all I have some problems with the "Flat File Source" ... I am trying to load a textfile, but IS allways cuts the rows ... When I look at the preview while designing, the row is complete, so I am wondering what IS is doing ... Thanks for any comments Best regards Frank Uray Here is what I am trying to load (one row from the file): WPBX1 1.2 19330065002695435000 001200526000 000020002002-11-13-11.17.55.2220262006-03-03-05.50.44.322629002000010001AG2006-03-03-05.50.44.322629WIS030EPF033200602173410567000101 271275 2006030220060303200603032006030320060303 200603032006030320060303 20060303200603032006 ...Show All
Smart Device Development Strategy/technology choice for Mobile App on VS 2005
We have a non-mobile web app which runs asp pages with a VB.NET 2005 business rules DLL in the middle and either sql or oracle at the backend. The VB.NET DLL is activex enabled. Now we are developing a mobile app in vb 2005 for mobile data collection. This is running Sql Server CE. I would like advice on the best way to connect the mobile application to the main app (a) when the app is connected on wireless or activesync and (b) when the app is disconnected. The web app already has an integration toolset so it can create and receive XML files and it can connect to external databases to import and export data. It seems a bit goofy to ...Show All
