dts - formatting excel sheet using activex script
I want to save the result of stored procedure to an excel file. So, I thought of creating a dts package for the same. But I am facing some problems here..
Can the transformation be done using ActiveX script instead of creating SQL and Excel connections ?
I want the the data to be formatted in the excel file. Is it possible to format the excel sheet using ActiveX script in dts?