Azure Datafactory V2 Truncates Decimals with Copy Procedure Activity RRS feed

  • Question

  • I'm trying to copy data from Azure SQL and transform it with a proc.  When I pass in the dataset to the table variable the decimal data has the decimals truncated.  So if I pass 1234.56 in to the table variable in the proc it becomes 1234.00.

    My work around is to dump the data into a working table, and just have the proc read from that table.

    Thanx, Adam

    Wednesday, February 7, 2018 2:41 AM

All replies

  • Have you fixed this? or are you still using that workaround? Facing the same issue here
    Monday, March 26, 2018 5:21 PM
  • MS Emailed me a few weeks ago and indicated it was a bug and they are working on it.  I have not retested to see if it was fixed yet.

    Thanx, Adam

    Monday, March 26, 2018 6:52 PM