Share via

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

Adam Fine 1 Reputation point
Oct 2, 2020, 8:29 PM

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.
11,436 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Evgeny Grishchenko 486 Reputation points
    Oct 4, 2020, 9:17 AM

    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?

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.