none
csv files in blob storage - numeric value showing as decimal in the dataset

    Question

  • Hi again,

    I have csv files in blob storage and they contain metrics. Just taking one metric. 807.

    I create the Linked Service and data set and when I preview the data its changed to 807.0

    As a consequence my copy is failing because my SQL Data base contains integers not decimals.

    Is there anything I can do about this in Data facrory. I dont really want to change my staging table to accept decimals and then add more transfarmation code to remove the 0

    Any help would be really appreciated

    Debbie


    Debbie

    Wednesday, October 17, 2018 1:56 PM

Answers

  • I think mine is slightly different.

    These posts seem to be talking about decimals rounded down but mine is about a whole number being turned into a decimal. 

    I found the issue thankfully. I went back to the Blob Data set and the schema and changed all the values from string to int32


    Debbie

    • Marked as answer by Debbie Edwards Thursday, October 18, 2018 8:54 AM
    Thursday, October 18, 2018 8:54 AM

All replies

  • I think this is an existing bug, could you please look here

    JAYENDRAN

    Wednesday, October 17, 2018 3:14 PM
  • I think mine is slightly different.

    These posts seem to be talking about decimals rounded down but mine is about a whole number being turned into a decimal. 

    I found the issue thankfully. I went back to the Blob Data set and the schema and changed all the values from string to int32


    Debbie

    • Marked as answer by Debbie Edwards Thursday, October 18, 2018 8:54 AM
    Thursday, October 18, 2018 8:54 AM