Post reply

SSIS package problem import excel file with more that 4000 columns

  • August 6, 2018 at 11:42 am

    #361786

    Hello, I'll try to explain the best posible, we are working with sql server express 2016, and we make ssis packages with the wizard to import excel files to sql tables, previously we imported file with 400 columns with out problem, but today have problem with this type of files, only show 225 columns, we are searc what is the problem but not find nothing, there is someone who has had the same issue, thanks for you attention.
    regards

    Angel Miranda

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

  • August 6, 2018 at 11:50 am

    #2000476

    Hmm... the problem is you have an excel document with 4000 columns....

  • August 6, 2018 at 12:51 pm

    #2000485

    What do you mean "this type of files"? Do you mean that the files are a different type to the previous files? Are they .xls instead of .xlsx?

    If not, could it be that you used the JET drivers? JET was designed for xls files from Excel 2005 and prior, instead of the ACE drivers for xlsx files from Excel 2008 and onwards. xls files can only store up to 256 columns, and JET therefore only supports up to that many columns. ACE on the other hand can handle up 16,384 columns, which is how man columns an xlsx file can also contain.

    But  Zzartin also raises a good point as well. A worksheet with 400+ columns is a little insane.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • August 6, 2018 at 3:10 pm

    #2000513

    Sorry for the title 4000, in resume put 400, for other side, we test with old files where imported correctly, and present the same issue, the infrastructure is the same, even so we are investigating with infrastructure área if they apply some update, Thanks for your advises

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

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

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