Forum Discussion

amaaiia's avatar
amaaiia
Icon for Skilled Sharer rankSkilled Sharer
2 years ago
Solved

Use Script parameters in Script activitie in Data Pipeline

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.

 

data engineering
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    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.

     

     

2 Replies

  • AndyDDC's avatar
    AndyDDC
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    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's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi amaaiia 

     

    Glad to know your query got resolved.

    Please continue using Microsoft Fabric Community for your further queries.

     

    Thanks.