how i have to see message in ssis

  • Hi gurus,

    in ssis i have package in that package under the dataflow task i have one source and transformation and destination.main problem is if transform the data from source to transformation i have to see message like if data transform sucessfully message is "Data Transform is sucess"

    if data transform with error message is "Data Transform with errors"

    how i can fix this.anebody help appricated

    thanks

    murali

  • Is it possible add a message in dataflow level pls tell me anybody

  • there might be more than one way.. but I might put the code in a try catch.. the last line in the try can do something like " Msgbox("Got to the bottom")

    and then in the catch you can say MsgBox("Crash and Burn") .. or some variation of that..

    this would only be a quick temporary fix..

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

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