SQL Script output

  • I have a pretty complex sql command (Script) in a DTS package. It has various prints in it. How can I log those to a file or to an output window?

  • Open the DTS package(design mode), select property's (right mouse) and choose which logging options you want.

  • Instead of using PRINT, you could insert your messages into a table in the database.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 3 posts - 1 through 2 (of 2 total)

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