SSIS: Export images embedded in Excel

Question

I have a VB6 application that takes an Excel spreadsheet with 2 worksheets, one for data and one for images, and saves the data and exports the images to a folder.

I would like to move this to SSIS but I can't find a way to export the images to a folder.

Any ideas?

Besides asking on SO, what research or work have you done to address this? — J Weezy, Jul 25 '18 at 21:54
I did my web searches prior and only found references to ADDING images to Excel and not exporting FROM via SSIS. — Jon, Jul 25 '18 at 22:54
Why do you want to move it to SSIS? That's a bad idea. Move it to a C# console app. — Nick.Mc, Jul 26 '18 at 00:35

score 0 · Answer 1 · answered Jul 25 '18 at 23:34

You will need to export the images to the file server and then import them.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/00b71581-cc36-4614-b6a9-4fc13c3220fe/import-images-in-excel-file-to-sql-database?forum=sqlintegrationservices

Export pictures from excel file into jpg using VBA

http://www.sqlusa.com/bestpractices/imageimportexport/

SSIS: Export images embedded in Excel

1 Answers1