I would like to back up the dts log files as a last step
in my dts package. (exception file and error file - are
there any others?).

My first choice would be to load the contents into a
column in the database. If this is not possible, then I'd
be happy just to copy the files to another location.

Does anyone know how to do this?

Thanks
Serge

You may have problems as DTS will keep them open for writing during the
package execution.
You may want to do this as an extra step in your process. Try it and see.


--
--

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

"Serge" <serge_delic (AT) hotmail (DOT) com> wrote