Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zatch
  • Order by date
  1. zatch

    e-mail warnings

    I've solved this. It was much simpler than I thought. Here are the steps I used: Go to the the Event Handlers tab of the package. Choose and Executible and Event handler from the Dropdownlists. In my case, I chose my package, and the "OnWarning" handler. Add a Send Mail Task to the...
  2. zatch

    e-mail warnings

    Hello - Does anyone have any thoughts as to how one would e-mail a list of warnings and/or e-mail an entire log file? I am trying to notify myself when the OnWarning event fires on a package. I can not figure out to access the log files. Thanks. Mitch
  3. zatch

    Any Thoughts?

    I'm using the Send Mail Task and pulling the MessageSource by using a variable. I also tried your double-quote suggestion by using the direct input option of the MessageSourceType property. Mitch
  4. zatch

    Any Thoughts?

    Thanks for your reply, Denny. Unfortunately, this does not work. It just adds the double quotes and yields a partial hyperlink like before. Mitch
  5. zatch

    Any Thoughts?

    Hello - I'm using SSIS to download/process text files. I have a 99% completed project. There is one small step which I cannot figure out how to do. I'm hoping you have some suggestions. When a file fails to process or has validation errors, I want to e-mail a user group and notify them...
  6. zatch

    Intercepting e-mail on exchange server

    Did you ever figure out how to do this? Thanks. Mitch
  7. zatch

    Get attachments from Exchange?

    Hello - I'm just curious to see if anyone has ever had (or has) any ideas about how one would tap into an Exchange Server and grab message attachments using SSIS and/or .net. I'm just looking for a solution where I don't have to have a mail client (Outlook) running on a server at all times to...
  8. zatch

    Datagrid LinkButton

    You are right. I thought I had two issues here, when really they were related. Thank you. Zatch
  9. zatch

    Datagrid LinkButton

    Thanks for your reply. Any ideas as to why the button is not raising the event? Zatch
  10. zatch

    Datagrid LinkButton

    I have a datagrid - datagrid1. At runtime, I am adding a ButtonColumn (Link Button) like so: Dim bc As New ButtonColumn bc.HeaderText = Format(dr.Item("PAYMENT_DATE"), "Short Date") bc.DataTextField = Format(dr.Item("PAYMENT_DATE"), "Short Date") bc.Text = Format(dr.Item("PAYMENT_DATE")...
  11. zatch

    How to pass parameter to DTSRUN for executing a package

    It's a little late, I suppose. But, in case anyone else is trying to make this happen, here's what I do. It could be shortened. Zatch www.mjlake.com CREATE PROCEDURE spExecDtsSpecific_Load ( @LOAD_NO int ) AS DECLARE @cmd sysname, @var sysname SET @var = @LOAD_NO SET @cmd = 'DTSRUN /S...
  12. zatch

    Rebind Datagrid

    That's a good idea, but I don't think it's practical for this project. The datagrid has the same behavior when adding records. Thanks again. Zatch
  13. zatch

    Rebind Datagrid

    My thinking is that I don't want to push any changes (edits, adds, deletes) to the database until the user decides they are completely finished manipulating records. I'm trying to avoid a call to the database each time they make a change to the dataset. A simple rebind (datagrid.databind) does...
  14. zatch

    Rebind Datagrid

    Is it completely necessary to update the database and refresh the dataset which the grid is bound to in order to get the datagrid to rebind to the dataset? sqldataadapter.update(sqldataset) sqldataadapter.fill(sqldataset) datagrid.databind I'd like to make changes only in the dataset itself...
  15. zatch

    control disposal

    Very nice. I've not stepped backward before. Thank you both. Zatch
  16. zatch

    control disposal

    Thanks for your reply, Rick. I changed your line: For i = Me.Controls.count - 1 to 0 to: For i = 0 to me.controls.count - 1 but it still did not work. Now I eventually get the error: "Specified argument was out of the range of valid values." It is looking for controls which it can't find...
  17. zatch

    control disposal

    I have a form with eight textbox controls on it. I have the following procedure which should delete each of the textboxes. What it really does is delete every other textbox on the form. I click a button to call the "Clear_Tbox" procedure and what I'm left with are Textbox2, textbox4...
  18. zatch

    SQL Server Going Nuts!

    On Sunday evening I restarted our SQL machine (which is running on MS SBS 2000 along with Exchange.) Until the last hour or so (Wednesday, noon) CPU usage stays between 15 and 30 percent normally. Now, all of the sudden, the processor is bouncing all over the place - from 5 to 100 and...
  19. zatch

    User Control - Button.default property

    Did you find a way to make this work? Thanks. Zatch
  20. zatch

    Trim 0's

    I have varchar field whose data looks similar to this: 0000345 0023456 0123456 0000001 What I need to do is "trim" the zero's from the beginning of each record. Any help is greatly appreciated. Zatch

Part and Inventory Search

Back
Top