Use Script parameters in Script activitie in Data Pipeline

[amaaiia]

I am using an Script activitie inside a Data Pipeline to make a SELECT statement, passing the table as parameters as follows:

But when executing the Pipeline I get the following error:

I've been able to pass Script parameters in other queries to WHERE clause (i.e. field1=@field_value), but I'm having troubles for field names.

[AndyDDC · Accepted solution]

Hi @amaaiia I'm not sure if object names are supported in the script activity parameters.  You could use the "dynamics expressions" and add the item to the script instead.  In the example beloe I'm using parameters, but you can use items as well.

[v-cboorla-msft]

Hi @amaaiia 

Glad to know your query got resolved.

Please continue using Microsoft Fabric Community for your further queries.

Thanks.