Forum Discussion

Darth_Pig's avatar
Darth_Pig
Copper Contributor
Jan 25, 2019

SSIS - Exporting Data from SQL to Excel

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

 
  • chanmm's avatar
    chanmm
    Copper Contributor
    Jan 26, 2019

    You can use File System Task to delete your Excel file in Control Flow below Data Flow Task 1.

     

    chanmm

Resources