I have a cursor that I am running to QC some data. I would like to output
the results to an excel file, but being that the cursor will return multiple
datasets I am not sure how to do this. I am doing some frequencies on the
data so for every field in my table I am doing a

select field_name, count(*)
from table
group by field_name

There are about 150 fields in the table that I want to do a frequency on,
and then output the results to excel. Would the best way to do this be an
ActiveX script in DTS or is there a better way. I am on SQL 2000. Any ideas?

Thanks

Ok so you could use this

How to loop through a global variable Rowset
(http://www.sqldts.com/default.aspx?298)

To get the attributes you want to do the substitution for.

You then use this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

To change the statement that you want to pump to Excel.

In an Active Script task within the loop you will issue a CREATE TABLE
against the XL connection to create a new sheet for yourself. You will
also set the DestinationObjectName to this new sheet name.

Allan


"Andy" <Andy (AT) discussions (DOT) microsoft.com> wrote