What is the best way to trace a DTS pkg execution so I can
see the code/script for every single step?

You should see the code being issued against SQL Server using Profiler.
Other RDBMSs may have their own implementations also.

You could also output the statement in tasks from your package using Script

--

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

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


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