AnsweredAssumed Answered

Using SSIS to Query an AF Table Lookup using a Table Parameter

Question asked by vwitzel on Nov 18, 2016
Latest reply on Nov 28, 2016 by vwitzel

Hi all,

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!

Outcomes