none
FireInformation doesn't

    Question

  • I am calling FireInformation in the PostExecute event of a Script Transformation configured as a destination (SSIS 2012, C#).

    The output will only appear (in the output window) if I place a break point somewhere in the code, otherwise nothing appears besides the standard SSIS output. Multiple calls are all ignored, also.

    Is there a project property that controls this output? Any ideas?


    Tuesday, June 25, 2013 12:30 AM

All replies

  • I was able to get it to output.  What code did you use to FireInformation?

    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com

    Tuesday, June 25, 2013 1:37 AM
  • I was able to get it to output.  What code did you use to FireInformation?

    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com

    So was I, just not in this component. Pretty-simple stuff, actually:

    bool fireAgain = false;
    this.ComponentMetaData.FireInformation(0, this.ComponentMetaData.Name, string.Format("The Component wrote {0} rows.", rowCount.ToString()), "", 0, ref fireAgain);
    ETA: yes, rowCount is previously defined, in scope and with a value.



    • Edited by D. Pendleton Tuesday, June 25, 2013 2:21 AM clarification
    Tuesday, June 25, 2013 2:05 AM
  • Tuesday, June 25, 2013 2:22 AM
  • I tried that--no luck.
    Tuesday, June 25, 2013 2:27 AM