I have created a DTS package to export data to 15 excel spread sheets. This data has to get refreshed every time i run the DTS. I am using
Drop table 'Excel_Sheet_1' in a SQL task before creating excel temp table. My problem is because i have created 15 excel temp tables for my 15 reports, if one of the table does not exist my SQL task errors out saying 'Table does not exist' when i try to drop the table. So what i want is i want to check whether the table exist before creating excel temp table. Please let me know if you have a solution or if you have any questions.