An error occurred while saving the commentJeff commented
This is going to be nuanced, but rather than have a postCopy script, I think a checkbox to indicate that the Copy job is loading into a temporary table would be sufficient to then inform ADF to require a following Store Procedure activity to execute immediately after in the same connection. I think this would be far more clear to illustrate the nuance (use case specific to temp tables) rather than a postCopy script. I can already see the confusion and annoyance between different developers battling over a postCopy script vs. a separate Stored Procedure activity.
I don't know much about preCopy scripts, but it's not immediately clear to me what the advantage of having a preCopy script vs. a stored procedure activity right before the copy activity provides?
154 votesJeff supported this idea ·