Intergration Service Catalog - Excel Error

Cameron Hicks 1 Reputation point
2021-02-16T06:40:35.033+00:00

Hi All,
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.

68573-loop.jpg

68439-report.jpg

Thanks for any help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,775 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cameron Hicks 1 Reputation point
    2021-02-17T05:32:25.553+00:00

    I downloaded and installed the Microsoft Access Database Engine 2016 again, 64 bit wont install as it correctly detects 32 bit excel. But there is no change, SSIS package continues to run within Visual Studio but fails after deployment to Catalog.

    I've tired running with 32 bit switch on and off.

    32bit switch on

    68942-32bit-error.jpg

    32 bit switch off

    68992-64bit-error.jpg

  2. Monalv-MSFT 5,896 Reputation points
    2021-02-19T08:02:20.95+00:00

    Hi @Cameron Hicks ,

    1.Please set Run64BitRuntime as True in ssis package.
    69994-run64bitruntime.png

    2.Please uncheck the 32-bit runtime in SSISDB Catalog.
    70024-ssisdbcatalog.png

    Best regards,
    Mona

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.