Recent content by zatch

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...

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

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

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

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...

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

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...

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

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

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")...

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...

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

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...

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...

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