November 10, 2008 at 7:56 am
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
November 11, 2008 at 8:56 am
Is it possible add a message in dataflow level pls tell me anybody
November 11, 2008 at 10:50 am
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