I am using Visual Studio 2017 with SSDT on windows server 2012 R2 Data Centre. The SSIS package to connects to excel spreadsheets and OLEDB sources/destinations etc.. I have installed the excel 2013 driver on my server and when I run the package within SSDT it works fine. However when I deploy to the SQL database instance of Integration Services Catalogs none of the excel connections work and I don't know why.
The SQL report shows error code 0xC020801C which I googled and talks about excel drivers but it already works in Visual Studio so IDK what the answer is.
Thanks for any help.