locked
All tables columns mapped to string data type RRS feed

  • Question

  • Dear,

    When I create a new pipeline all columns mapped to string data type and the pipeline failed when running the activity which copy  from data lake to table with the following error 

    Message=Input string was not in a correct format.,Source=mscorlib,'", "failureType": "UserError", "target": 

    Regads' 

    Wednesday, October 31, 2018 4:30 AM

Answers

  • Hi Amit

    Thank you very much 

    I used JSON format it gives the correct format for mapping and after that you can change the file type back again to text file 

    Regards'

    Wednesday, November 7, 2018 10:35 AM

All replies

  • Could you provide the activity id?
    Wednesday, October 31, 2018 5:27 AM
  • Hi Ghassan,

    You can load the data into the Stage tables first as is with string datatype and then from stage to target you can change the data type accordingly.


    Cheers,

    • Proposed as answer by Jason_J (Azure) Wednesday, October 31, 2018 7:43 PM
    Wednesday, October 31, 2018 6:58 AM
  • Hi Amit

    Thank you very much 

    I used JSON format it gives the correct format for mapping and after that you can change the file type back again to text file 

    Regards'

    Wednesday, November 7, 2018 10:35 AM