SSIS - Data Load Using Excel Source

  • balu.arunkumar

    Ten Centuries

    Points: 1021

    Hi All,

    I am trying to load Excel(2017) data into SQL Server using SSIS. When i try to load directly , it is throwing error.

    Error : External Table is not in the Expected Format

    But when i open and saving that same excel file as .xlsx format it loads without error.

    How to solve this issue?

  • DinoRS

    SSCrazy

    Points: 2592

    Check your Excel source if it's for the right version of Excel file

     

    excel

  • balu.arunkumar

    Ten Centuries

    Points: 1021

    Dinors,

    When i select the excel file  the excel version is automatically changed to "Microsoft Excel 2007-2010"

  • Phil Parkin

    SSC Guru

    Points: 243910

    Please expand on this:

    But when i open and saving that same excel file as .xlsx format it loads without error.

    What format was the file in before you opened and saved?

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • balu.arunkumar

    Ten Centuries

    Points: 1021

    Same .xlsx format only in both operation

  • DinoRS

    SSCrazy

    Points: 2592

    have you verified on the file properties before and after opening & saving the xslx file that it's for the same version of Excel?

  • Chris Harshman

    SSC-Forever

    Points: 41901

    Can you try to verify the actual file type before you open it in Excel?  I've seen some people do silly things like name a plain text file with an Excel file extension just so that it becomes the default program to open it.  Excel allows this and will try to figure out the format then.  SSIS is more strict and if you tell it the file is Excel workbook it must be.  Maybe try opening the file with notepad or something to see what it looks like?

Viewing 7 posts - 1 through 7 (of 7 total)

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