I have a proc that does some insert/updates for each Row run through an OLEDB command. If certain non "batch/scope" aborting things happen, I want to return a 1 from the proc to use as notification this record did not process , and allow the calling program (in this case the SSIS component) to handle the record differently. Is there a way to get the return code ( Exec @return_code = pr_proc ?).?
Cheers
http://twitter.com/widba
http://widba.blogspot.com/