SSIS - Capturing Query Messages

  • Hi folks. SSIS is a new product for me and I’m having a bit of trouble capturing some data. What I would like to see is the information, which would normally be spit out into the messages tab in SSMS or Query Analyzer, from a series of queries I run. I’ve tried turning on logging for the package and outputting that data to a csv and while this does give me some useful information, it’s not exactly what I’m looking for. How can I obtain the information I am seeking? Thanks in advance.

  • Stephen Scott (10/2/2009)


    Hi folks. SSIS is a new product for me and I’m having a bit of trouble capturing some data. What I would like to see is the information, which would normally be spit out into the messages tab in SSMS or Query Analyzer, from a series of queries I run. I’ve tried turning on logging for the package and outputting that data to a csv and while this does give me some useful information, it’s not exactly what I’m looking for. How can I obtain the information I am seeking? Thanks in advance.

    Stephen,

    The SSIS components are not in any way related to the components used in SSMS or Query Analyzer. If the SSIS components doesn't include enough information in the log, you have to address this issue with Microsoft by posting a feature request here.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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