I tried to delete the worksheet using excecute sql task. But i m getting a error "sysntax error in drop table or drop index". possible failure reasons" problems with the query,"resultset" property not set correctly,parameters not set correctly.....",when i execute the data manager package.
Syntax i was using to delete is drop table 'members'. "members" is the work sheet name, i want to delete.
Any help on this will be appreciated.