operand type clash:image is incompatible with xml

When i try to insert the dynamically created xml into a temp table its shows a error

"operand type clash :image is incompatible with xml".

I already split the query when I execute the query and just select the xml its working .Only problem is that its not allow to insert into a table.

   "SET @sSQL1 = '
     SELECT  ' + @ColumnList + '
     FROM TB1 IPI WHERE  TBID= ' + CAST(@ID as varchar(10)) +' FOR XML RAW (''TB'') ,ROOT(''Table'') '

INSERT INTO @TBLTRANSXML(INCTRANSXML)           
EXEC (@sSQL1)"

The code is attached as picture

Please help its urgent.