Hi

I need to export out a bunch of files on a regular basis
to Text files. Can I use Dynamic properties to set this up
and not have to do any Activex scripting ?
On the same vein, can I set up a DTS package to run on
several servers that can be setup Dynamically ?
I am using SQL Server 2000 (SP3) on Windows 2000.

Thanks,

Venkatesh

If I needed to export a series of tables to text file and those tables were
able to change evry time I would probably use BCP.
I would create a script that went through the tables I needed and executed

You can use DTS on almost anywhere that has the DTS dlls registered

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

Making a pakage as dynamic as possible and not in need of constant tweaking
should be a goal of the DTS package designer.

Look at the dynamic Properties task/ DTSRUN (/A switch)

Have a look around the site www.SQLDTS.com and you will find examples of
what you need.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Venkatesh" <vaiyar (AT) hotmail (DOT) com> wrote