For example:

create function internal.get_execution_perf_counters

(

@execution_id bigint

,@execution_guid uniqueidentifier

)

returns table

(

execution_id bigint null

,counter_name nvarchar(128) null

,counter_value bigint null

)

with execute as caller

as external name

ISSERVER.[Microsoft.SqlServer.IntegrationServices.Server.ExecPerfCounterApi].GetExecPerfCounters;

go