Search results for query: *

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

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

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

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

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

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