Post reply

Export data to Excel failed after SQL Server 2019 upgrade

  • September 13, 2022 at 3:58 pm

    #4087179

    Hi,

    I have a package that retrieves data from a SQL database, and then exports it to an Excel file.  The package was built with Visual Studio 2019 (Targeted SQL Server 2017). Everything runs fine for years until recently we upgraded the SQL Server to 2019 from 2017.  I rebuilt the package and targeted to SQL 2019.  When executing, I got the following error message:

    [Excel Destination [16]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209303.

    Please help.

    Thanks,

    Jay

  • September 13, 2022 at 4:13 pm

    #4087186

    You are seeing this error locally in SSDT, on the server, or both? Is this the same server that was running 2017, or a new server?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • September 13, 2022 at 4:47 pm

    #4087192

    I only get this on my local settings. I don't have a sample package on the server. It is a development server. And it is the same server, but upgraded SQL version.

    • This reply was modified 2 years, 1 month ago by  jay-125866.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply