Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
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:
error:
Message=A database operation failed with the following error: 'Incorrect syntax near 'csv'.',Source=,''Type=System.Data.SqlClient.SqlException,Message=Incorrect syntax near 'csv'
Solved! Go to Solution.
@arkiboys 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
@arkiboys 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
Hi @arkiboys
Thanks for using Fabric Community.
Can you please provide the screenshot of the pre copy script which you used in the pipeline?
Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.