Delete Excel sheets in DTS

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply