Drop table in pre-copy script

user_1113490 0
Viewed 580

sink-configuration

I am trying to parameterize the pre-copy script to DROP existing tables of the same schema and table name from a SQL Server sink. I have tried variations of the above, what's the correct syntax to use the dataset properties in the pre-copy script?

Additionally, is there a good resource on using the dynamic content in ADF?

azure-data-factory azure-sql-database
1 Answers

Reviewing other questions with parameterized query steps, the parameters are incorrectly prefixed, the following was executed successfully:

DROP TABLE IF EXISTS @{item().TABLE_SCHEMA}.@{item().table_name}
user_11134900
Related