Im running SQL 2000 ( SP3 )

I have several DTS's which contain Activex Tasks. Is there a simple way to get a print of all of the code in each task other than opening each one and doing a copy / paste to word doc or similar

You can use the object model

1. Loop through Tasks
2. Find Active Script tasks
3. Grab the ActiveXScript property



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

doing a copy / paste to word doc or similar