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:Detailed code provided in the following link: