VincentITA's Q&A profile

• SQL Server Can I add a record number as data passes through

  Hello. In SSIS, is it possible to add a record number to each row of data as I copy it from the source to the destination. An example of my source data is below, For each MemberID want to record the number of times it occurs in the table.  MemberID 2898  2899 2899 What I want it to look like when it gets to the destination is: MemberID     RecordNumber 2898     1 2899     1 2899     2 Like an Identity column I suppose, not for the whole table but for each MemberID. Thanks     bobbins wrote: Hello. In SSIS, is it possible to add a recor ...Show All

• SQL Server Calling user-defined functions in OLE DB Command transformation

  Hi We have a user-defined function that can be called directly via SQL (in SQL Server Management Studio) without error. We would like to use this function to populate a column, whist data is being processed within Integration Services. Using an OLE DB Command transformation to achieve this would seem the most appropriate. The following was inserted for the SQLCommand property: EXEC = dbo.GetOrderlineStatus(@dt_required = , @dt_invoice = , @dt_despatch = , @ch_status = , @si_suffix = , @re_quantity = , @vc_invoice_id = , @vc_order_id = ) However, when the Refresh button is pressed we are presented with the error below: Error at Load Orderline [OLE DB Command [15171]]: An OLE DB error has occurred. Error code: 0x8004E14. An OL ...Show All

• SQL Server Legacy DTS packages

  How can I scheudule a legacy DTS 2000 package if it stored in SQL Server itself I assume the package 'lives' in the msdb database. For what bizarre reason is there no option to schedule legacy packages anyway, why provide the DTS legacy/designer components if the ability to schedule them isn't possible Is this microsoft's subtle way of telling me that I should convert them to SSIS packages ...I just don't have the time to do that...help Thanks Thanks for the swift reply So, if my package it called test and it lives in msdb how what do I need to put in at the command line I never directly used dtsrun in SQL2000, I scheduled the packages from the designer which created the jobs ...Show All

• SharePoint Products and Technologies Should we care about session timeout?

  Someone in my team requesting that we extend session timeout for SharePoint to 4 hours so when he had to go to the washroom or take his lunch he should be worry about his session to be killed. I couldn't give answer to what is the importance of session time out feature -if I can call it feature- Can someone educate me if there is any harm of expanding session time out from 30 minutes to 4 hours (besides that someone else can use your computer in your absence to access areas using your profile) Thanks! Mohamed Mohamed, I am not an expert on these issues, but guessing from what I know I would say this is also a resources problem. The more you expand timeouts, the more chance you have of people leaving op ...Show All

• Visual Studio Tools for Office Avoiding security alert in Outlook while accessing Contacts in VSTO 2005

  I am trying to access Items programmatically within a VSTO 2005. When I try to access the 'magic' properties such as email1address, I get the security warning within Outlook. I do not want to go back to redemption - that's why I am using VSTO. How do I avoid the security warnings when doing something like the following: private void Form1_Load(object sender, EventArgs e) { LoadContacts(); } private void LoadContacts() { Outlook.NameSpace outlookNameSpace = Globals.ThisApplication.GetNamespace("MAPI"); Outlook.MAPIFolder contactsFolder = outlookNameSpace.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderContacts); Outlook.Items contactItems = contactsFolder.Items.Restrict(" ...Show All

• Windows Forms Problem with TextBox and MS Access

  I am writing a form with serveral textboxes, those textboxes are going to display serveral records with same criteria. How can I show those records on those textboxes Dim ShowPhonestrSelect As String = "select autoid, id, phone, type, phone & type as showphone from phone where id = '" & CboFiltered.SelectedValue & "'" Dim ShowPhoneDA As New OleDb.OleDbDataAdapter(ShowPhonestrSelect, ShowPhoneconn) Dim ShowPhoneDS As New DataSet ShowPhoneconn.Open() ShowPhoneDA.Fill(ShowPhoneDS, "phone") What should I do then Thank You Are you going to show different records at the same time If you only show one records at the time and you are using text ...Show All

• SQL Server Notification services failed to open a connection to SQL Server.Server name:ABC(Microsoft.SqlServer.NotificationServices)

  I am getting the above error when I try to create Notificatioin services new Instance. Additional Information is Failed to connect to server ABC(Microsoft.SqlServer.ConnectionInfo) An error occured while establishing connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server deoes not allow remote connections.(Provider : Named Pipes Provider, error 40 -could not open connection to SQL Server)(Microsoft SQL Server error: 53) Please help me I am new to SQL Server 2005.I can't able to proceed. These questions may so ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Terrain Options

  Hi Whats better for implement terrain -Use the content pipeline for load then .x file with the terrain or -implement de class for convert the pixels of .raw file in vertex with the height (y axi) dependent of de gray color I have problem whit the first option becose a can't extract the vertexs of vertexbuffer becose the vertexbuffer is WriteOnly What I can do thank's I've been working on a Terrain Generator basically just to learn how to implement terrain. I got it working pretty well. However, since I did it in Windows Forms on a panel, it hasn't performed that well. I'm going to create a better camera, move it to a game and get it working. However, the technique I learned involve ...Show All

• Visual FoxPro Disabling "Open" window

  Hi All, We have lots of previously written programs. We have an automated system calls them 24/7. Occasionally they are crashing or bringing up a table open window and stop running. I have control over crashes. But "Open" window needs human intervention, so I don't know if it's working or waiting for an entry. Here is an example: procedure myProgram * Codes Insert into myTable (myField) values ("myValue") * more codes Return If myTable doesn't exist or for some reason we loose the connection with the network drive, it can't find the table and opens up a "Open" window to choose a table to use. Since I have bunch of programs, it's not easy to go and modify all of them one by one. Is there any way to prevent o ...Show All

• Visual Studio In Copy-Modify-Merge can you force a get if local version is not based on the latest?

  I'm switching to the copy-modify-merge model. As I understand it, if the version a file has been checked out against is stale, sourcesafe does the merge on checkin whereas in TFS and SourceGear Vault you are forced to get a latest version and do the merge locally before checking in. The latter seems to me to be a much better practice -- is there a way to get this behavior in sourcesafe In the event that you cannot do this, is there a way (even if through a third party add-in) that I can see a list of local files that I have made changes to that will require a merge on check-in (i.e., files that other users have updated since I last checked them out) At least this would allow me to exercise some care with the files that will be merged on ...Show All

• Smart Device Development Example of using delegates and callbacks from managed to native code needed

  In C# I call a function from a native code dll and need to get a callback so I know when to continue. Currently the native code sends a message on successful completion which I can get by overriding WndProc but I think a callback from the native code would be a much better solution. Because the native code writes a file and for various reasons its not really acceptable to constantly be checking to see if the file exists so my managed code needs to know when the successful write occurs. Can someone point me or provide me with some example code of this in action Here's a classic example of using delegate for call back from native to managed. Keep in mind these call backs only supported in NETCF V2. ...Show All

• Visual Studio Express Editions HelpFile In VB Express??

  Is there a way to create a helpfile (I believe that's what it is called) where users can see a list of Help Contents and search for keywords similar to most Office applications Thanks, John take a look at this: http://www.microsoft.com/downloads/details.aspx familyid=00535334-c8a6-452f-9aa0-d597d16580cc&displaylang=en maybe take a look at this too: http://www.helpware.net/mshelp2/demo2/h1xNET.htm ...Show All

• Software Development for Windows Vista Unable to do Response.Write("")

  Hi! I am new to WF and have written small application to do some processing in the Workflow and get back the resulting variable and write that variable onto the webform. But ASP.NET is saying Response.Write is not available during this context, and before application reaching the breaking point the form was completely processing and is reaching the client. Is it because of the asynchronous processing.. !!! I am using the WorkflowCompleted event handler to do the Response.Write. Will be thankful if any one can help me in this regard. Thankyou Hemanth. Hemanth, Welcome to WF. It seems you are a bit confused about the separation of the workflow host and the workflow instance in WF. The workflow host is responsible ...Show All

• Visual C# Understanding best use of config files for Web Applications

  Hi, Web Applications use the web.config file however they do not seem to allow me to add extra parameters that I need. (Note: The extra parameters do not always relate to the normal items stored in this config file) For example, I would like to add something similar to the following: <myUniqueConfigSettings> <add name="MyUniqueSettings" myUniqueSettingString="blah; blah;"> </myUniqueConfigSettings> Is this possible Or do I have to create my own separate config file for such items and read from that Thanks in advance Andrew The web.config file works just like a normal application configuration file. In order to add ...Show All

• Windows Forms Maintain caret position in textbox

  I have this textbox on a form. I want to prevent the textbox's caret position from being affected by any mouse events at all. How do I do this How do I block all mouse activity from affecting the carets position If you're just looking for digits, I recommend using the MaskedTextBox control, or the NumericUpDown control. MaskedTestBox has it's quirks; but some folks have improved upon it, like Irena Kennedy and her CurrencyTextBox class . ...Show All