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 12:22 pm

    #1594116

    Chances are you have your Flat File Connection Manager setup incorrectly. When you go to Preview, does your data line up? If not, make sure you are accounting for the End Of Line characters in your column-definitions.

    If you're stuck zip your SSIS Package and a few lines of your data file to this thread and I'll have a look.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato