Try to use Dynamic SQL:
declare @sql varchar(max)
set @sql="BULK INSERT #mytable FROM "'' + @path + ''' WITH ...
exec (@sql)
Try to use Dynamic SQL:
declare @sql varchar(max)
set @sql="BULK INSERT #mytable FROM "'' + @path + ''' WITH ...
exec (@sql)