none
All tables columns mapped to string data type

    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,

    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