Jan 25 2019 06:13 AM
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?
Thanks
S.
Ps: I apologize for my terrible English
Jan 26 2019 04:47 AM
You can use File System Task to delete your Excel file in Control Flow below Data Flow Task 1.
chanmm