CODEWITHSUNDEEP
azure-data-factory
Blue Clouds
Blue Clouds

Reputation: 8161

ADF Copy activity Sink Pre-copy script timeout

I have a pre-copy script DELETE FROM mytable where ID=123

This timed out (after 4 hours)

Then I gave TRUNCATE TABLE mytable and I got the error 'Table does not exist or no permission' .

I am able to insert from ADF copy. But on pre-copy or on lookup query . I get the errors state above. What could be wrong?

Upvotes: 0

Views: 517

Answers (1)

Leon Yue
Leon Yue

Reputation: 16431

In Lookup active, your query DELETE FROM mytable where ID=123 and TRUNCATE TABLE mytable doesn't return any result.

Please ref the Look up active note:

  • When you use query or stored procedure to lookup data, make sure to return one and exact one result set. Otherwise, Lookup activity fails.

Just according the error message, please make sure you're using the user/account which have enough permission to delete the data in Sink linked server dataset.

Upvotes: -1

Related Questions