Post reply

Logging in ssis

  • July 8, 2008 at 10:53 am

    #193528

    Hi,

    I am using logging(text files) in all my SSIS packages. So, everytime the package runs the log text file grows larger. Is there any way to overwrite the previous logs, i mean I just want to see only latest log information. Please let me know if we have any option for this.

    Thanks in advance...

  • July 9, 2008 at 1:11 pm

    #840470

    Could you find the Append output file ... checkbox and uncheck it in your DTS package?

  • July 9, 2008 at 1:15 pm

    #840473

    Thanks for the reply....but wher can I find that?? u mean in the logging window ?? In logging window I don't find anything like that....

  • July 9, 2008 at 1:25 pm

    #840478

    Here's one way...

    If you use the command line utility dtsexec, you could create a batch file. The batch file would do 3 things:

    - Delete any old log file

    - Rename the current log file to something that identifies it as old log file (extn as .old perhaps)

    - Call the dtsexec and use .dtsConfig file which contains connection string info, log file info/path etc.

    The vision must be followed by the venture. It is not enough to stare up the steps - we must step up the stairs. - Vance Havner

  • July 9, 2008 at 1:34 pm

    #840481

    Thanks for the reply....but we r gonna schedule the package to run everyday... from ur post, It looks like everyday we have to give the new logfile name in .dtsconfig file. is that right?? can u give me 1 example of batch file??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply