Execute SQL statements using the new 'Script' activity in Azure Data Factory and Synapse Pipelines

Hi,

Do I have an option to pass output on my first script as input to my second script in the same script activity.

Hi 

when ever am running store proc using script activity it’s run for 30 mins & getting fail !! Please help on this 

Error : The Sql parameter is already contained by another SqlParameterCollection

Any suggestions for that .

Regards

pravern 

Hi,

Same Error. Script activity is failing with Timeout error

 The activity is running fo

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

When run over than 30min, it always shows time out, whether the time it is setted.

Why is the Script activity listed under "pipeline activity" instead of "external activity" in the pipeline debug run consumption?

I am trying to create a database trigger using Script activity. It works if I use it without paramer, but adding a parameter (and then using it or even not usig it in the CREATE TRIGGER statement) give me an error - 'Incorrect syntax near the keyword 'trigger'.'

Hello everyone, 

I tried to call a Snowflake stored procedure with string parameters, but I always get an error message:

Have you encountered a similar problem? 

Now it is telling me it can only run constant literals? It won't even accept my basic test insert: 

INSERT INTO GRANTSDM.NIHAPIPullLog (NIHFilterKeys, FiscalYear, CallCriteria, TotalRecords, PullDateTime) values (1, 2012, 'Test Criteria', 1234, GETDATE())

 

kristofferabs 

Using pipeline parameters and variables instead of script parameters works for me. 

Using dynamic content you can reference parameters and variables inside @{ reference / expression }.

Example of dynamic content:

Select * from [@{pipeline.parameter.schema}].[@{pipeline.parameter.table}]

JoshWU 

Script activity always fails for me. I've tried running with hardcoded values, script parameters, and pipeline parameters and they always fail no matter if I run an insert, update, or select. It gives me a generic error about direction that I can't find anything about then that's it and it does this with everything I've tried in the activity.