SSIS - Exporting Data from SQL to Excel

Copper Contributor

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 correctlyE2003_1.jpg

 

E2003_2.jpg

 

E2003_3.jpg

 

 

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.

E2010_1.jpgE2010_2.jpgE2010_3.jpg

 

 

Can someone tell me the reason?

Thanks

S.

 

Ps: I apologize for my terrible English

 
1 Reply

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

 

chanmm