Im strugling with calling the stored procedure ( create in SSMS, azure serverless pools) in ADF and sink to AZURE Database.

I have a Copy data activity, my Source dataset is linked to my synapse analytics serverless pools

My Sink is connected to Azure SQL database parameter in the Sink coming from the Azure SQL database Dataset.

This is where I want to write output from storeprocedure. Porblem is that I could not figure out how I could TRUNANCATE TABLE in Pre-copy-Script.

CodePudding user response：

There is a text box for pre-copy script on your 2nd screen dump.

Just add TRUNCATE TABLE YOURTABLENAME in the box. Replacing YOURTABLENAME with the actual name of your table.