Excel format in Azure Data Factory. A welcome addition to ADF!
When adding an ADF DataSet:
I am convinced they got tired of me saying, “Well, you’ll need SSIS if you want to read Excel…” Probably not, though. Either way… score! :{>
Need Help Migrating to Azure?
Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. We’ve earned our blood-, sweat-, and tear-stained t-shirts. Reach out. We can help.
Andy, were you able to use that Excel file as a source in ADF? I managed to get my files created and linked. I can preview them, but can’t seem to select them as a source in my ADF. It’s great that there’s an option, but not sure how to actually _use_ it now.
Hi Peter,
I have not yet attempted to read or write Excel files in ADF.
:{>
Seems like Copy activity does not support excel as sink, do we need to use dataflow for excel as Sink?