I solved all the issues with this post.
The named instance was key to the issue. There is a special flag and parameter needed to successfully connect to a named instance via the command window.
The format 'database.table' for the source object parameter (taken from SQL Server Help) is incorrect. After trying many different formats for this parameter, I discovered it. I have not seen the specific problem documented anywhere.