locked
Json Path schema issue in Copy Activity RRS feed

  • Question

  • I am accessing a REST API and sinking data to an Azure Blob before copying to an Azure SQL.  I have 2 different feeds. One is working perfectly.  On the other I keep getting the following error:

    Column 'vRMSMax#2' contains an invalid value '246.5'. Cannot convert '246.5' to type 'Int64'.. Activity ID:25495fb0-2677-4970-8125-48d4e7a274e1

    Even after I updater the column type and publish the changes, it reverts back.  At a loss for why this is happening or how to fix.

    Sunday, March 24, 2019 6:43 AM

All replies

  • Hi Matt,

    When do you hit this error? Could you share a screenshot? From the activity Id, seems you are using Copy Data (wizard tool) ? 

    Then how do you update the column type and publish it? Do you have an activity id when you run the copy?

    Sunday, March 24, 2019 2:31 PM
  • '246.5' is not an integer value.  You need to explicitly cast to an integer or otherwise remove the fractional value.

    "@int(<referenceThecColumn>)"

    Tuesday, March 26, 2019 12:39 AM