Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Delete Excel sheets in DTS Expand / Collapse
Author
Message
Posted Monday, February 18, 2008 11:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase

Permissions Expand / Collapse