You can use a script task to achieve that, you can benefit from the `Microsoft.Interop.Excel` library to achieve that, you can copy the image from a file using the following code:

    Image ExcelImage = Image.FromFile(strFilePath);
    System.Windows.Forms.Clipboard.SetDataObject(ExcelImage ,true);

And paste it to excel sheet using the following code:

    Excel.Worksheet ThisSheet = (Excel.Worksheet)ThisWorkBook.Sheets[1];
    Excel.Range oRange = (Excel.Range)ThisSheet.Cells[10,1];
    ThisSheet.Paste(oRange,ExcelImage);

**Detailed code provided in the following link:*

- [How to programmatically add a Picture or Icon to an Excel WorkSheet using C#](https://social.msdn.microsoft.com/Forums/vstudio/en-US/5bb5eb47-ea5e-4d97-a794-6266122552ea/how-to-programmatically-add-a-picture-or-icon-to-an-excel-worksheet-using-c?forum=csharpgeneral)