Hi,

does it possible to log the DTS execution to a database which is NOT MSDB?

I have a VB program which create an inmemory DTS package then execute it,
now I want to activate the log but I want to log the execution into a
specific database instead-of MSDB. I can do this by code, but its time
consumming (and not bug free)

thanks for your ideas.

Jerome.

The only thing that comes to my mind is to query the MSDB in your package
(Using a SQL Execute Task) and insert the fields you want to the table you'd
like to have the information in.In this way you don;t need to change your VB
code and only a task is added to the existing workflow.
--
HTH,
Reza Alirezaei
http://blogs.devhorizon.com
"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote