You can use 'Send Mail Task' from the control flow items in the toolbox.

But this is a simple text based email (optionally with attachments).

If you want to generate HTML based...

It would only limit the resource when there is competition to acquire resources.

vibhasjog ,

Please check if you are using transaction in this step in case you don't have your linked server configured for this.