Hi @nasreen-akter @MartinJaffer-MSFT @HimanshuSinha-MSFT
In a COPY Activity I am reading a JSON file which has as the first item is employeeid such as 010004.
Most of the employee id's begin with a ZERO. My issue is that when the Copy Sink is an Excel spreadsheet and the employee is copied without the leading zero, such as 10004. I think Copy this Spreadsheet into a DB Table. In the DB Table the employee id has NO leading zero.
How can I get the leading zero back into the COPY Output so that the employee id is 010004 and the ERP will recognize it?