How do I copy data from a zipped excel file into a csv Azure Data Factory

Adam Fine 1 Reputation point
2020-10-02T20:29:58.31+00:00

Hello, I am currently having a bit of trouble trying to use the copy data activity to move my source (which is a sftp) to grab a zipped excel file, and drop it in my sink(which is a blob storage container) now when I move it it is turning the zipped file into some type of encrypted txt file. I am trying to either preserve the excel file, or transform it into a csv and cannot seem to find a work around

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,048 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Evgeny Grishchenko 486 Reputation points
    2020-10-04T09:17:15.137+00:00

    Hi @Adam Fine ,

    • Which value for "compression type" does the source service have?
      • If you click preview, does it show the correct data set?
    • Which value for "compression type" does the sink service have?
    • Have you checked your mappings?