Sounds like you're running into the x64 issue. VS 2019 is x86 and therefore you probably installed the Office x86 version of the driver so it works. However SSIS is running x64 and you don't have the x64 driver installed so it fails to find it. Can you install the x64 version of the driver on your SQL Server instance? That is the way to go but note you cannot install both Office x86 and x64 on the same machine as mentioned here. But since you need to install it on your SQL Server and SQL is most likely x64 this shouldn't be an issue.
If for some reason you cannot install and use the x64 version of the driver then you have to tell SSIS to run your package in x86 mode instead. If you set the package properties (Debugging) Run64BitRuntime
to false then that runs under x86 mode. If you're running your SSIS package in project deployment mode then there is a 32-bit flag you have to specify so SSIS runs using the x86 toolset. If you're using SQL Agent then you have to ensure you point it to the x86 version of DTExec instead. There are several articles on this but I haven't tried it myself. Here's one such article.