Home Forums Data Warehousing Integration Services Simple SSIS failed with The value could not be converted because of a potential loss of data. RE: Simple SSIS failed with The value could not be converted because of a potential loss of data.

  • February 22, 2017 at 10:50 am

    #1929790

    Phil Parkin - Wednesday, February 22, 2017 10:41 AM

    Can you show us what is happening in the Data Conversion task, please?

    Also, include an example of the data in 'Val COArea Crcy'.

    What is the OLEDB source pointing at?

    Thank you.

    Conversion task:

     example of the data in 'Val COArea Crcy':

    OLEDB source:

    Top 10 of the table:

    Thank you again for your time.