locked
Truncated Error Messages RRS feed

  • Question

  • When designing an SSIS package, a red icon with a white cross is displayed in the component if there is something wrong. If you point to this icon a message appears which is often truncated. Any ideas how to recover the whole message?

    The "important bits" are not necessarily at the begining of the truncated message. Googled this for ages with no luck and it's not intuitively obvious what the answer is.

    Rgds, Don_Quixote


    Tuesday, October 25, 2011 3:29 PM

Answers

  • when the package is open, just go to View Menu and click on Error List then you will be able to see the error listed.


    Senior BI Consultant & PM @ Nexum Bogazici
    If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.
    Visit: ssisnedir.com Follow Me
    • Marked as answer by Don_Quixote Wednesday, October 26, 2011 2:05 PM
    Tuesday, October 25, 2011 5:05 PM

All replies

  • when the package is open, just go to View Menu and click on Error List then you will be able to see the error listed.


    Senior BI Consultant & PM @ Nexum Bogazici
    If it is, Please dont forget to mark as answered or at least vote as helpful if the post helps you in any ways.
    Visit: ssisnedir.com Follow Me
    • Marked as answer by Don_Quixote Wednesday, October 26, 2011 2:05 PM
    Tuesday, October 25, 2011 5:05 PM
  • Hello,

    Try to open advanced editor (rigth click in the component -> Show advanced editor) usually the error message will display in there.

     

    B. Regards.

    Wednesday, October 26, 2011 10:57 AM
  • Many thanks Onur. It's all so very obvious when you know where to look.

    Rgds, Don_Quixote

    Wednesday, October 26, 2011 2:07 PM
  • See Onur's reply above. Spot on.

    Many thanks for your response.

    Rgds, Don_Quixote

    Wednesday, October 26, 2011 2:08 PM