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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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.