How to connect the vertica in SSRS

See more:

SSRS

this is my sql in sqlserver

Declare @SQL varchar(max)SET @SQL ='select c.pid,''Not Exists'' as Pstate from( SELECT '''+REPLACE(@JoinID,',',''' pid UNION ALL SELECT ''')+''' pid ) c where c.pid not in
(SELECT   pn_id FROM  pytable )' 
exec(@SQL)
else
begin
select null as Psatet, null as split 
end

I need to use the sql in a report that the data source pointed to a vertica

when I set the commandTest like this:

set v1 'NTR.pytable'; select pn_id from :v1

It shows error:

Unsupported SET option v1


knows what to do ? thanks