Never mind, the SQL task had the wrong connection. It works now, if the Excel file exists. Is there a way to check if the file exists before dropping it? I tried : IF NOT (OBJECT_ID('Screwup') IS NULL) DROP TABLE Screwup
but I get an error. Where can I find the syntax I can use here?
Terri
To speak algebraically, Mr. M. is execrable, but Mr. C. is
(x+1)-ecrable.
Edgar Allan Poe
[Discussing fellow writers Cornelius Mathews and William Ellery Channing.]