Re: log into a different database than MSDB?
- From: "Reza Alirezaei" <Ralirezaei@xxxxxxxxxx>
- Date: Tue, 9 Aug 2005 11:37:39 -0700
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_@xxxxxxxxxxxxxx> wrote in message
news:OJQIzTPnFHA.4032@xxxxxxxxxxxxxxxxxxxxxxx
> 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.
>
>
.
- References:
- log into a different database than MSDB?
- From: Jéjé
- log into a different database than MSDB?
- Prev by Date: Re: Scheduled DTS package fails even if SQLSERVERAGENT logs on as owner
- Next by Date: Re: Execute ASP page from DTS
- Previous by thread: log into a different database than MSDB?
- Next by thread: SQLDTS.com and SQLIS.com are back up.
- Index(es):
Relevant Pages
|
