Post reply

Excel Column widths larger than 255....

  • November 28, 2005 at 3:21 am

    #67020

    Hi,

    I am putting together a DTS package that will import from excel.

    My users wish to populate a spreadsheet with strings upto 1000 characters in length but excel doesn't allow lengths greater than 255 and i suspect DTS will cause similar problems.

    Any advice out there on this?

    Any help welcome,

    Eamon

  • November 28, 2005 at 6:16 am

    #606048

    Although the maximum column width in Excel is 255 characters, that is not the maximum length of data that can be stored in a column, which is 32,767 characters.

    DTS will cope with this no problem, as far as I know.  Just map to a suitable VARCHAR field in SQL Server and you should be fine.

    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

  • November 29, 2005 at 7:33 am

    #606408

    Just remember that SQL only has a max record length of 8,000.

    Shalom!,

    Michael Lee

  • November 29, 2005 at 8:03 am

    #606420

    thanks guys !!

    this all very very helpful

    Eamon

  • November 29, 2005 at 10:50 am

    #606478

    Yes, but don't you have to do a disconnected edit in DTS to handle columns larger than 255?

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

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