Thank you for your feedback. We are evaluating this ask and will keep everyone posted on future plan for this.
Please let us know if there is plan in the future for this. Currently the best option to do this seems to be using SSIS IR in ADF V2 and calling SSIS package to read the Excel source. Our client wanted to go completely with ADF without SSIS IR. However we proposed SSIS IR for reading excel as we didnt want to go for a custom activity to read excel due to the time limit. This is a much wanted feature.
This is very vital to support movement of ADF projects across environments using Visual studio configurations as well as for ease of development. Please support.
Is it planned in near future? Many activities like delete blob and move blob can be easily done in ADF with Powershell.
[Update] Thanks for your continued feedback on this capability! Rest assured that we are tracking this request closely along with several other platform capabilities our customers have requested. In the meanwhile, you can leverage cluster scaling capability to adjust HDInsight cluster size according to your varying compute needs. Azure Data Factory is another option you can explore for scheduling jobs with automatic creation and deletion of clusters: https://azure.microsoft.com/en-us/documentation/articles/data-factory-data-transformation-activities/
Microsoft Azure HDInsight
754 votesunplanned · AdminSQL Database feature voting forum admins (Product Owner, Microsoft Azure) responded
Not planned at this time. Will keep this item open for future review.
64 votesunder review · 3 comments · SQL Data Warehouse » Performance · Flag idea as inappropriate… · Admin →