Catching invalid DB account issues
I would like to trap and route errors where the host name or database name on a SQL Server account is not valid and therefore an error is thrown when trying to use the account in a SQL Server Select ...
Forum Discussion
It WOULD be nice if they had this functionality, but it seems many ETL tools don’t. One thing you can do is have a simple process start THIS process, using a pipeline execute, and trap the error THERE. That is what I am doing for a similar problem in snaplogic. Also, don’t forget to add exit to THIS pipeline as well as the one I am talking about, so an error triggers a failure. That way if even the last pipeline fails on the lowest level, the upper level will show an error, so you can handle it all the conventional ways.
Steve
