Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

copy activity - pre-copy script

hi, In the pre-copy script box of the copy activity, I place this tsql statement but the pipeline gives this error. any suggestions? thank you   my script: @concat('delete from db_name.tbl_name...
Pipelines
  • NandanHegde's avatar
    NandanHegde
    2 years ago

    Anonymous  Couple of things for which we need details :

    1) what is the database (type) on which you are executing your pre copy script?

    2) based on the expression : 
    @concat('delete from db_name.tbl_name where file_path = ', 'Source/mydata-new/mydata-03-May-2024.csv')

    This seems to be pretty static, not sure why you used the concat here?

     

    3. Also as stated by Nikhil, please provide the screenshot of the log of the Copy activity so we see what SQL command was generated and actually executed

NandanHegde's avatar
NandanHegde
Super User
2 years ago

Anonymous  Couple of things for which we need details :

1) what is the database (type) on which you are executing your pre copy script?

2) based on the expression : 
@concat('delete from db_name.tbl_name where file_path = ', 'Source/mydata-new/mydata-03-May-2024.csv')

This seems to be pretty static, not sure why you used the concat here?

 

3. Also as stated by Nikhil, please provide the screenshot of the log of the Copy activity so we see what SQL command was generated and actually executed