Hi All,

I use the DTSRUN utility with /L option to provide the log filename with
path for logging.

I think in Package property "Error File" option is same as the above but
there the NAME will be given in design time.

Also there is an option to log to SQL Server - MSDB and also to eventlog.
Which method is the best for ERROR Log? Can any one explain with detail or
any website link that explain all that?

Thanks
Prabhat

It depends on who require the data. if the data is being used my
Network/System Administrators then you can log it into Event Log. If Database
Administrators are going to use the data then u log it on MSDB.

If the data is required by the Application Suport Team the u can log it into
a flat file or one of the tables in the Production Database.

Where ever you log the data its one and the same.

hope this answers the question.

thanks and regards
Chandra


"Prabhat" wrote:

Hi Chandra! Thanks for your reply.

Prabhat


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

Good to know that the solution addressed your needs. Really appreciate if you
can rate the Post.

This can be done by answering "Was this post helpful to you?"

"Prabhat" wrote:

Hi Chandra,

Yes This Post was answered my question and Helpful to me. Thanks.

Can U please look into my Post "DTS - With Conditions" and Help me in that?

Thanks
Prabhat

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

Hi Prabhat,
I will try to answer your post "DTS - With Conditions".

for more information on rating the post, please refer to
http://www.microsoft.com/wn3/locales....htm#RateAPost

thanks and regards
Chandra


"Prabhat" wrote: