Hi Russel,

I am back again. I was on vacation these days so couldnt check your message. I tried giving

if DTSGlobalVariables.Parent.Tasks("DTSTask_DTSDataPumpTask_2").CustomTask.RowsComplete = 0

before but it didnt work for me. Can you please help...

The task should not run when the number of errored records is zero. if there are any errored records it should send to the excel and then send an email...

Hi i am back again. The active x script works fine but a problem here.

Function Main()

if DTSGlobalVariables.Parent.Tasks("DTSTask_DTSDataPumpTask_2").CustomTask.RowsComplete < 0 then

' 0 or some other threshold

  Main = DTSStepScriptResult_DontExecuteTask

else

  Main = DTSStepScriptResult_ExecuteTask

end if

end function

what...

if anyone can give me a solution for xp_sendmail that would be great. I didnt use xp_sendmail till now and this is the first time i tested with it. Just...

I just modified my DTSPackage and the activexscript worked perfect with out failing the package.

sorry its my fault; didnt make the connections properly.

Thats really good. Thanks a lot RLoski...

a typo mistake

but why is it working if i omit the attachments. i am getting the email. does it effect anything if i...

yes its working if i omit the last line. is my query correct?

Hi sorry to get back again. but i see a problem here. In my dts package i have few other steps that needs to be performed after i send the...

Hi Luciano,

The other solution worked but just curios to know as to why the xpsend_mail errored out when i run with attachments? any idea. Did i mention anything wrong in...

the step executed successfully. The name should be DTStask_DTSDataPumpTask_2. Thanks a lot for your help.

yes the file to be attached is present.

This is the code i am using

EXEC master.dbo.xp_sendmail @recipients = 'xxx@xxx.com',

   @subject = 'Error Report',

   @message = 'Please check the Errors in...

Thanks for the quick response. sorry to bother but can you see this code

Function Main()

if DTSGlobalVariables.Parent.Tasks("DTSStep_DTSDataPumpTask_2").CustomTask.RowsComplete < 20 then

' 1 or some other threshold

  Main = DTSStepScriptResult_DontExecuteTask

else

  Main =...

Hi

I tried both the options, the first one is giving an error when i include the attachment in the xp_sendmail

The second option is giving me the following error.

Error Source...

Thank you so much for the replies. I will try those.

Thanks again

The mail profile in sql agent properties under the general tab is selected correctly.

I saw few issues hope this helps:

I logged into that server in which i am finding issues...