Errors: Message Processor Error: Open Failed! or The advanced settings for this source object are invalid. You must fix them in order to continue opening this Translation Spec.

Issue: When either opening an existing dts that makes use of the Update Source functionality, in either the Workbench, or attempting to run it in the console I receive errors:

When it attempts to run in the console it fails with the error: Message Processor Error: Open Failed!

When I attempt to open it in the Workbench the errors are: The advanced settings for this source object are invalid. You must fix them in order to continue opening this Translation Spec.

The Advanced settings will be cleared for the source data object query because of an invalid setting.

Solution: Open the dts in the Workbench (click through errors), reenter any settings that previously existed in the Update Source settings (any text entered here now needs to be surrounded by quotes (ex/ " text" ) and then save the dts.

Posted by Morgan P. on Apr 4 2009 12:19PM { U61 , F8 , T524 , C1148 }

(3) Answers

Login