How can I view the DTS log and login information.
Pls help.

The DTS log?

DTS does not log unless you tell it to. This is available in the package
properties and you can, in the current version, log to text file and SQL
Server. Once you have these you can simply look at them.

Login information?

Of what the connections?

You could loop through the connections and see if the connection is used
"Trusted" or has a user name

--

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


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