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 8:00 am

    #1593986

    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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.