Using #temp tables inside Stored Procs not supported for SSIS as a Datasource from DWH
Currently we can't use a #temp table inside a Stored Procedure as a datasource in SSIS from Azure Datawarehouse.
Currently the two most used options ("SET NOCOUNT ON", and "WITH RESULT SETS") are not supported in Azure Data Warehouse.
This would be really useful to enable the flexibility to offer a Stored procedure for data extraction with defined parameters as inputs to filter the result set for our consumers.

Thanks you for the request! We have put this on our backlog and we will update this item as we move forward.