I need to run 5 different Select Count(*).........
Statement from the DTS package and get the result out to
the text file. What is the best way to do this ? (It has
to be a DTS package and not any other method Jobs, SP
e.t.c.)

Thanks.

I suppose you are going to also say

The number of columns may change in each run
You do not want to change anything after the first build
Everything is flexible

Are you?

That done with then Using DTS may be a problem, well maybe.

You can call bcp from DTS.
You could build your own custom task to do this.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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