SSIS - Excel Macro

Question

Hello,

I have an SSIS ETL that moves excel files from a local folder and inserts the data into a SQL database.

I'm running into some issues with a the excel files being in two different formats breaking the ETL mappings.

I've created an excel macro that converts the format of the file into one standard format.

Can someone help me have the SSIS ETL open the excel file and run the macro in the beginning of the ETL run?

Any help would be greatly appreciated.

Thanks,

Tim

Answer 1

Hi Tim,

The following links will be helpful:

Run Excel Macro using SSIS Script Task

ScriptTask for Run the Macro code on Excel save Excel file as txt

Best Regards,
Mona

---

If the response is helpful, please click "Accept Answer" and upvote it.