I have an AF Table that uses a Table Parameter (@API), as you can see in the below query, and an AF Attribute configured as a Table Lookup Data Reference (TLDR) pointed to this AF Table, as you can see in the below screenshot.
AF Table Query
select assetname, objectid, 11 objecttype, replace(apiwellnumber,'-') from propertywellinfotb where propertywellinfotb.groupid in (1) and replace(apiwellnumber,'-') = @API
AF Attribute Configured as TLDR
When I query for this Attribute using SQL Commander, it resolves without issue, as you can see in the below screenshot. It also resolves when I configure an OLEDB data source within Excel.
However, when I try to automate the query execution using SQL Server Integration Services (SSIS), it is unable to resolve the Table Parameter, as you can see in the below screenshot.
Are Table Parameters in TLDRs perhaps not supported by SSIS, or do I perhaps need to query for this attribute differently? Appreciate any insights you can share!