Export data to Excel failed after SQL Server 2019 upgrade

• jay-125866

  SSCommitted

  Points: 1629

  More actions

  September 13, 2022 at 3:58 pm

  #4087178

  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

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  September 14, 2022 at 4:10 pm

  #4087687

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.