Home Forums Data Warehousing Integration Services Length of field imported from CSV file cut off at 255 characters RE: Length of field imported from CSV file cut off at 255 characters

  • August 27, 2012 at 4:14 pm

    #1530555

    I ran the following query:

    SELECT Notes

    FROM Tasks_import

    WHERE len(Notes) = 255

    Then I copied and pasted several values from the Notes field results into NotePad and I could see that the sentences were cut off. This also returned about 40 records. When I ran the following query looking for Notes values greater than 255 characters in length, no results are returned.

    SELECT Notes

    FROM Tasks_import

    WHERE len(Notes) > 255

    I also spot checked the CSV file for several of the 40 records mentioned about and could see that there is more information in the CSV file than is being imported to the database table and cut off at 255 characters.