When trying to create a 2003 excel spreadsheet, I received "spreadsheet is full" error. I changed my Engine to ACE and Excel version to 2007 and extension to XLSX. My Drop Table SQL task doesn't work as before and the Create Table Table SQL Task. Actually, it appears that the drop table works however, the create table says the table already exists. What's going on? The file path is accessible to the SQL server.
Thanks
