dts - formatting excel sheet using activex script

Najmunnisha · April 30th, 2007, 05:57 AM

Hi,

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?

Najmun

jemacc · April 30th, 2007, 10:20 AM

try this site it may helphttp://www.breakingpar.com/bkp/home.nsf/0/87256B280015193F87256E32007BC6B1

Jaime E. Maccou

jilly · May 17th, 2007, 10:27 PM

I recall that Excel can save a spreadsheet as an XML file and maintain formatting. I think (given what you've asked) that one option may be trying to use an ActiveX script to emulate the XML format that Excel produces.

Just a thought...