Thanks mrrobsewell & Leonard. Both solutions are good. thank you.

@mrrobsewell - I need a small help. Considering Leonard solution, how can format in such a way so that Report,...

Finally was able to fix the issue. Added below 3 lines and it worked like a charm. Thank you so much for the continous help Leonard.

$message = New-Object Net.Mail.MailMessage($EmailFrom, $EmailTo,...

Hi Leonard,

Now everything is working fine. Email is being sent to the recipient but the format is not getting display in proper HTML format.

But if I go to...

I slightly modified the catch block to display the exception.

catch [Exception]

{

Write-Host "$_.Exception.GetType().FullName, $_.Exception.Message" -ForegroundColor Red

}

}

Then as suspected it was throwing below runtime error

New-Object...

Thanks a lot HanShi.

Hi Leonard,

I dont know why but the script is getting executed but the data is not showing up. PFA screenshot.

Could you please help me in fixing it.

Thanks you very much for the help . Will check Leonard.

Thanks a ton Hanshi.

Thanks a ton Jacob and Nicholas.

Thanks Sue. Will do that and monitor.

Hi Experts,

Any thoughts??

Hi Experts,

Any thoughts??

my comments

1) How large are the data sets which are being processed in the SSIS packages?

The sets are quite large. 2-3 millions rows.

2) Are...

Thanks Jacob for the help.

Hi All,

I was doing some home work on query timeouts. Came across the interesting blog from Jonathan kehayias. He demonstrated a nice way of capturing the queries which are getting...