Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I select a task map I get error message "Source View vw_ViewName used in the mapping does not exist in the database". Then the edit mapping window opens and the Landing Zone Columns section and the View dropdown options are empty.
The view exists in the source database and the user account has access to it.
You probably need to clear the metadata cache and/or the landing cache.
You probably need to clear the metadata cache and/or the landing cache.
Thanks, went into Manage under DW and the "Clear Landing Cache" did the trick.
The only other suggestion I can think of would be to change the project settings to check "Generate DDL scripts but do not run them", then generate instructions for the task that uses the source view, and then go back to the project settings, uncheck the same box, and then generate the instructions again. Sometimes that gets the metadata in sync when clearing the cache doesn't work.