topic Re: Use Script parameters in Script activitie in Data Pipeline in Data Engineering

Use Script parameters in Script activitie in Data Pipeline

amaaiia — Sat, 09 Mar 2024 15:13:04 GMT

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.

Re: Use Script parameters in Script activitie in Data Pipeline

AndyDDC — Sun, 10 Mar 2024 11:34:41 GMT

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.

Re: Use Script parameters in Script activitie in Data Pipeline

v-cboorla-msft — Mon, 11 Mar 2024 15:38:16 GMT

Hi amaaiia

Glad to know your query got resolved.

Please continue using Microsoft Fabric Community for your further queries.

Thanks.