Jan 25 2019
Hi everyone, I have a problem with exporting from SQL to Excel, a different behavior from Excel version (2003) to another (2010).
Excel 2003 - Everything runs correctly
Excel 2010 - The first time runs correctly, but from the second, the task that creates the Excel table (sheet) gives me an error because the table already exists.
Can someone tell me the reason?
Ps: I apologize for my terrible English
Jan 26 2019
You can use File System Task to delete your Excel file in Control Flow below Data Flow Task 1.