Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    23

    Unanswered: Create My Own Log (for functionality)

    I'm calling stored procedures in a DTS package. The log file only shows that of DTS. In stored procedures I use "Print" to print out error messages the program encouters. I can see the errors when I execute a procedure in Query Analyzer, but they go nowhere when I run a DTS package.

    How do I generate a myfunctionality.log with these lines?

    Thanks,

    Lili
    DTS -> Oracle

  2. #2
    Join Date
    Apr 2002
    Location
    VA
    Posts
    18

    Create Log

    Hi,

    The best way to add Own Log functionality , is to create a log table and use insert statement to log message instead of print. The advantage will be that log will be available for future reference whereas filelog will be over written every time you run package.

    best of luck
    Deepak Khattar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •