log into a different database than MSDB?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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.


.



Relevant Pages

  • Re: How share program files folder on LAN?
    ... Install the application on both computers. ... >computers are trying to access the database at the same time. ... registry entries that control the program's execution. ... Please post any reply as a follow-up message in the news group ...
    (microsoft.public.windowsxp.network_web)
  • Re: As a generale rule - Query or VBA?
    ... I agree with you Rick, I was recently working on a database that had ... the query is saved, then JET will save the fastest execution path. ...
    (comp.databases.ms-access)
  • TransferObjectsTask
    ... I'm writing a utility, in VB6, to create a new database for non-dba's ... My problem area is almost certainly concerned with the access rights. ... The execution of the following DTS Package succeeded: ... Package Execution Lineage: ...
    (microsoft.public.sqlserver.dts)
  • Re: ADO Performance
    ... loading a whole table into a recordset is often necessary if it's a config table or such but if it's a large table you could try and place some logic on the server side to reduce the execution time. ... many ways, but at the database part, it does the same). ... I also checked the .vbp files, ...
    (microsoft.public.vb.general.discussion)
  • Re: SQL
    ... >>> that are stored in the database. ... > Similarly, in the relational data model, where rows have primary keys by ... > In that case, the business logic is represented as code in a language, ... Execution is a necessary step, but not necessary one to get all cought ...
    (comp.object)