Anybody out there have any experience with catching an error from DTS
w/ Informatica?

Issue is that DTS packages are being execute as a task within
Informatica workflow as either "pre-sql" or as "sql query", when DTS
package fails Informatica does not pickup the error. Actual step
command is xp_cmdshell 'dtsrun...' I've tried wrapping in a stored
procedure, or sql statement, forced an error with raiserror, etc. and
Informatica just doesn't catch the error?

Any help appreciated.

Thanks,

Tom