Home Forums Data Warehousing Integration Services The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". RE: The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

  • March 6, 2013 at 9:54 am

    #1594057

    Phil Parkin (3/6/2013)

    quillis131 (3/6/2013)

    Phil Parkin (3/6/2013)

    opc.three (3/6/2013)

    quillis131 (3/5/2013)

    I have a csv file (FIXED Width)

    Files are either delimited, e.g. a CSV file, or fixed width. Which is it that you are dealing with?

    What got my attention was that I initially read it as

    ".. a csv file (FIXED Width) with one clown ... "

    🙂

    Its is CSV file with one Column as Fixed width

    No it isn't. It is either CSV or Fixed Width, not both.

    Its a Fixed Width File