I have created a dts package where in which I am pulling a data from sql server to excel. before doing this I have used a activex script to run a macro that deletes the old data. But I am getting an error while doing this. Below is the error I a getting.

Error Description: Error Code:0
Error Source: Microsoft Excel
Error Description:The macro 'Macro1' cannot be found.

But the macro name is correct as mentioned it is Macro1 and the file path is also correct.

From http://developmentnow.com/g/103_2003...server-dts.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/