Will you please post your active script task code to call EXCEL macro?

Thanks.

Also I have error to run the DTS. it said syntax error in the drop table or drop index. I also tried to DROP TABLE 'authors'

DROP TABLE 'authors'

 GO

CREATE TABLE `authors` (

`au_id` VarChar (11) ,

`au_lname` VarChar (40) ,

`au_fname` VarChar (20) ,

`phone` VarChar (12) ,

`address` VarChar (40) ,

`city` VarChar (20) ,

`state` VarChar (2) ,

`zip` VarChar (5) ,

`contract` Bit  )