Forum Discussion

Pfisterbi's avatar
Pfisterbi
Icon for Advocate I rankAdvocate I
3 years ago

SQL Statement "OUTPUT" is not supported.

Hi In our DWH (an ASQL DB), we use a SP at the start of the ADF Pipeline to write some metadata about the Pipeline into an Audit log (table in DB).  The following code is an excerpt of the code:   ...
data warehouse
HimanshuS-msft's avatar
HimanshuS-msft
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Hello  Pfisterbi
I am assuming that the code which you shared is from the SP . I will suggest you to please comment the below line and try again . 

insert into logging.adf_run_log (master_pl_run_id, parent_pl_run_id, pl_run_id, execution_object, source_object, layer, status, start_time)

-- OUTPUT inserted.pl_run_id

select ISNULL(@master_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier)) , ISNULL(@parent_pl_run_id,cast('00000000-0000-0000-0000-000000000000' as uniqueidentifier)) , ISNULL(@pl_run_id,NEWID()) , @execution_object, @source_object, @layer, 'RUNNING', getdate()


Please do let us know how it goes .

 

Thanks 
Himanshu