Delete Excel sheets in DTS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Delete Excel sheets in DTS

Delete Excel sheets in DTS

Rate Topic

Display Mode

Topic Options

Author

Message

gowdara.anu

Posted Monday, February 18, 2008 11:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2008 11:47 AM
Points: 3, Visits: 11

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.

Post #457001

« Prev Topic | Next Topic »

Permissions