How do I manipulate Excel files in SSIS

[WhoWantsTacos]

I'm in the process of converting some DTS packages to SSIS packages and one of the tasks involves manipulating an Excel file (deleting rows, adding columns, rename things, data integrity checks, etc.).

I need to programmatically modify the Excel file into a useful format before I can use it as a datasource. This works perfectly in the DTS ActiveX Script task, but was the equivalent in SSIS Script Task removed?

Thanks