All geek questions in one place

How to process Excel files stored in image data type column using SSIS package?

I have a .NET webforms interface that allows administrators to upload two .xls files for offline processing. Since these files will be used for verification (and aggregation), I save them in the image field in the table.

My ultimate goal is to create an SSIS package that will process these files offline. Does anyone know how to use SSIS to read a blob from a table in its own (in this case .xls) format for use in a data flow task?

+3
source share
2 answers

In my (admittedly limited) experience with SSIS, it’s pretty good to type and run something quickly, but it’s depressingly limited to getting something that “feels” as the most elegant, effective solution for a programmer.

Since the Excel source code editor seems to accept only files as input, you need to provide it with a file or override its functionality in code that blob can accept. I understand that this is unsatisfactory, but, in the end, it is a tool to save time.

+1
source

Export column Conversion should do the trick. Check: MSDN Export Column Transformation .

+1
source

Source: https://habr.com/ru/post/1696499/

More articles:


All Articles