Hi,

I want to export the definitions of my DTS packages to do an ascii search on
my script code...

Is that possible?

Thanks, José Araujo

You can save the DTS Packages as a VB file from Enterprise Manager. I think
that will give you what you are looking for. In the DTS Package Designer,
choose Package|Save As.. and choose Visual Basic File from the Location
drop-down list.

--
Jacco Schalkwijk
SQL Server MVP


"José Araujo" <josea (AT) mcrinc (DOT) com> wrote

That's correct, but if you have 100 DTS packages that is not an option if
you want to look where some tables are being used... (that's my case)

Thanks, José.

"Jacco Schalkwijk" <jacco.please.reply (AT) to (DOT) newsgroups.mvps.org.invalid> wrote
in message news:OFfvUlvfEHA.3632 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Whilst you cannot automate the save to VB to get text files, if you
think of DTS as what it is not just a script as you would with SQL then
you have a better solution. DTS is just a COM structure, and as such you
can write some code that can load a package and enumerate objects in
that package, read properties or do whatever you like basically.

To find tables that are used you would enumerate tasks looking for
DataPumps, DDQs, Bulk Inserts, and Exec SQL Tasks, then examine the
properties such as SQLStatemnet, SourceObjectName,
DestinationObjectName, and perhaps check for any lookups and drill into
them as well.

Make sense?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Yes, it does...

Thanks... José.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote