"External table is not in the expected format"

• Reh23

  Old Hand

  Points: 360

  More actions

  February 6, 2025 at 3:56 pm

  #4531363

  Good Afternoon.

  I have been manually running an SSIS package on an adhoc basis, which populates an Excel file from a SQL Server Table. There is no apparent issue with the package, but often I get the following error:

  "External table is not in the expected format"

  And it resolves when I Shut Down and Re-Start the machine.

  Sometimes it does not work on the first run after the Re-Start but maybe the second or third run. The SSIS Container dedicated to populating the Excel file, actually fills multiple Sheets/Tabs. And when it does fail, it fails randomly on a different Sheets/Tabs (instead the same one every time). And maybe on the very subsequent run of the entire package it will run completely fine and populate all the Sheets/Tabs (without having made any modifications to the package !).

  I would appreciate advice on resolving this perplexing issue.

   

   

  • This topic was modified 4 months, 1 week ago by Reh23.
  • This topic was modified 4 months, 1 week ago by Reh23.
  • This topic was modified 4 months, 1 week ago by Reh23.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  February 7, 2025 at 4:10 pm

  #4532271

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

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