0

I'm struggling 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:

enter image description here

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

enter image description here

This is where I want to write output from the stored procedure. Problem is that I could not figure out how I could TRUNCATE TABLE in Pre-copy-Script.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Greencolor
  • 501
  • 1
  • 5
  • 16
  • 1
    Write the truncate table script in pre-copy script text box. Check this [img](https://i.imgur.com/yXsRF9y.png) – Aswin Dec 10 '22 at 16:10
  • 1
    FYI, you can upload images straight onto [so]; please don't upload them to a different site to then have to have us open a webpage and then click on the image... – Thom A Dec 10 '22 at 17:05

1 Answers1

1

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.

Shiraz Bhaiji
  • 64,065
  • 34
  • 143
  • 252