SSMA for Access Console Issues

Question

I am attempting to automate the process of migrating an Access database to SQL Server via the SSMA Console. The process works flawlessly via the GUI, but the console seems to have a very basic, but common coding issue -- or I'm missing something.

Here is what is happening:

I have used the sample scripts to customize my needs as they seem to provide everything I need -- that being a very basic access database being linked into a very basic sql database...

I have built a batch file that executes the following: 
SSMAforAccessConsole.exe -s script.xml -c server.xml -v variables.xml -l log.txt

The console ends with this message: 
[2/4/2013 11:44:49 AM]    START map-schema
FATALERR Access Database was not found by name 'Test_Access_Database'

In locating the map-schema line (in script.xml) it reads:
<map-schema source-schema="$AccessDatabase$" sql-server-schema="$SQLServerDb$.dbo" />

Referencing the AccessDatabase variable line, which reads:
<variable name="$AccessDatabase$" value="Test_Access_Database.mdb"/>

I know that the AccessDatabase variable is being read properly prior to this, in-code, because if I change the value to an incorrect file name it will ding me with the ".mdb" still appended... and I am sure that this is the area where it is breaking because if I, for example, "hard-code" a '1' before the variable  the error reads:
FATALERR Access Database was not found by name '1Test_Access_Database'

A common mistake made by programmers (being one myself) is to unintentionally parse a string containing a file name through a function that removes the file extension (thus giving just the file's root name)... I believe this is the case with this scenario.

Obviously I could be mistaken, or I could just run it manually, but I need this to be an automated process as it is a part of my company's life-cycle and they require their database admins to execute and test the process.

Please let me know as soon as possible if I'm making a simple mistake, or of any work-arounds or patches that could allow me to continue using this product as a solution -- as it does appear to be the most accurate and dependable process available for performing this task.

Here is my full list of scripts being used:

(Please note that all of my Schemas are in a custom directory, thus I have removed one '.' directory iterator from my scripts)

script.xml

<?xml version="1.0" encoding="utf-8"?>
<ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\A2SSConsoleScriptSchema.xsd">

  <config>
    <output-providers>      
      <output-window suppress-messages="false" destination="file" file-name="./LogMessages.txt"/>

      <upgrade-project action="yes"/>
      
      <user-input-popup mode="continue"/>

      <data-migration-connection source-use-last-used="false"
                                 target-server="$SQLServerName$"/>

      <progress-reporting enable="true"
                          report-messages="true"
                          report-progress="every-1%"/>

      <reconnect-manager on-source-reconnect="reconnect-to-last-used-server" 
							           on-target-reconnect="generate-an-error"/>

      <object-overwrite action="overwrite" />

      <log-verbosity level="error"/>

    </output-providers>
  </config>

  <script-commands>

    <create-new-project project-folder="$project_folder$" 
						project-name="$project_name$" 
						overwrite-if-exists="true"
						project-type="$project-type$" />

    <load-access-database database-file="$AccessDbFolder$\$AccessDatabaseFile$"/>

    <connect-target-database server="$SQLServerName$" />

    <map-schema source-schema="$AccessDatabase$" sql-server-schema="$SQLServerDb$.dbo" />

    <convert-schema object-name="$AccessDatabase$" 
                        object-type="Databases" />

    <synchronize-target object-name="$SQLServerDb$.dbo"
                        on-error="report-each-as-warning"
                        report-errors-to="$SynchronizationReports$" />

    <migrate-data object-name="$AccessDatabase$.Tables"
                  object-type="category"
                  write-summary-report-to="$SummaryReports$"
                  report-errors="true"
                  verbose="true" />

    <link-tables>
      <metabase-object object-name="$AccessDatabase$.Tables" object-type="category"/>
    </link-tables>

    <save-project />
    <close-project if-modified="save" />
  </script-commands>
</ssma-script-file>

variables.xml

<?xml version="1.0" encoding="utf-8"?>
<variables xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\ConsoleScriptVariablesSchema.xsd">

  <variable name="$WorkingFolder$"  value="."/>

  <variable-group name="AccessConnection">
   <variable name="$AccessDbFolder$" value="\\US_SERVER1\admin$$"/>
   <variable name="$AccessDatabase$" value="Test_Access_Database.mdb"/>
   <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.accdb"/>
  </variable-group>

  <variable-group name="SQLServerConnection">
    <variable name="$SQLServerName$" value="(local)"/>
    <variable name="$SQLServerDb$"  value="TEST_SQL_DB"/>
  </variable-group>

  <variable-group name="TEST_SQL_DB">
    <variable name="$project_folder$" value="$WorkingFolder$\$project_name$"/>
    <variable name="$project_name$" value="TEST_SQL_DB_TEST1"/>
    <variable name="$project-type$" value="sql-server-2008"/>
    <variable name="$ConvertARReportsFolder$"  value="$WorkingFolder$\$AssessmentReportFolderName$"/>
    <variable name="$SynchronizationReports$" value="$WorkingFolder$"/>
    <variable name="$SaveScriptFolder$" value="$WorkingFolder$"/>
    <variable name="$AssessmentReportFolderName$"       value="AssessmentReports"/>
    <variable name="$AssessmentReports$"                value="$WorkingFolder$\$AssessmentReportFolderName$"/>
    <variable name="$SummaryReports$"                   value="$WorkingFolder$"/>
  </variable-group>
</variables>

server.xml

<?xml version="1.0" encoding="utf-8"?>
<servers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation=".\Schemas\A2SSConsoleScriptServersSchema.xsd">
  <sql-server name="(local)">
    <windows-authentication>
      <database value ="$SQLServerDb$"/>
      <server value ="$SQLServerName$"/>
      <encrypt value="true"/>
      <trust-server-certificate value="true"/>
    </windows-authentication>
  </sql-server>  
</servers>

Log Results:

[Command Line Processor: Mandatory] [6156/1] [2013-02-04 12:53:03]: Microsoft SSMA for Access v5.2.1257
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Start Validating command sequence....
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Validating command sequence finished....
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: #### Start processing command sequence...
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: ## Processing command #1
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: ## Command code: create-new-project 
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: CommandStarted was called with command code: create-new-project
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: Creating project 'TEST_SQL_DB_TEST1' in folder '.\TEST_SQL_DB_TEST1'
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 1%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 2%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 3%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 4%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 5%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 6%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 7%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 8%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 9%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 10%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 11%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 12%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 13%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 14%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 15%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 16%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 17%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 18%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 19%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 20%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 21%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:03]: WriteCommandResult was called with result code 'progress-pct', and value: 22%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 23%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 24%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 25%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 26%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 27%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 28%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 29%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 30%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 31%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 32%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 33%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 34%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 35%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 36%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 37%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 38%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 39%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 40%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 41%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 42%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 43%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 44%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 45%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 46%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 47%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 48%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 49%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 50%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 51%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 52%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 53%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 54%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 55%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 56%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 57%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 58%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 59%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 60%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 61%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 62%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 63%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 64%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 65%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 66%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 67%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 68%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 69%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 70%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 71%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 72%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 73%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 74%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 75%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 76%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 77%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 78%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 79%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 80%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 81%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 82%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 83%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 84%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 85%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 86%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 87%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 88%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 89%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 90%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 91%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 92%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 93%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 94%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 95%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 96%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 97%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 98%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 99%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 100%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Project created
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #2
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: load-access-database 
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: load-access-database
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteWarningMessage was called with message: No files found with pattern '\\US_SERVER1\admin$\Test_Access_Database.mdb.accdb'
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #3
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: connect-target-database 
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: connect-target-database
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Establishing connection to sql-server server '(local)'
[Generic: Error] [6156/3] [2013-02-04 12:53:04]: Exception: The remote server returned an error: (407) Proxy Authentication Required.
 site: System.Net.WebResponse GetResponse()
 source: System
   at System.Net.HttpWebRequest.GetResponse()
   at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload()
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 1%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 2%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 3%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 4%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 5%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 6%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 7%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 8%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 9%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 10%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 11%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 12%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 13%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 14%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 15%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 16%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 17%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 18%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 19%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 20%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 21%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 22%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 23%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 24%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 25%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 26%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 27%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 28%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 29%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 30%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 31%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 32%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 33%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 34%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 35%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 36%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 37%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 38%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 39%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 40%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 41%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 42%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 43%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 44%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 45%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 46%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 47%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 48%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 49%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 50%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 51%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 52%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 53%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 54%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 55%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 56%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 57%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 58%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 59%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 60%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 61%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 62%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 63%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 64%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 65%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 66%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 67%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 68%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 69%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 70%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 71%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 72%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 73%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 74%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 75%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 76%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 77%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 78%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 79%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 80%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 81%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 82%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 83%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 84%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 85%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 86%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 87%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 88%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 89%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 90%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 91%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 92%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 93%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 94%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 95%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 96%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 97%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 98%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 99%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: WriteCommandResult was called with result code 'progress-pct', and value: 100%
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandFinished was called
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command processed
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Processing command #4
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ## Command code: map-schema 
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: CommandStarted was called with command code: map-schema
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: ReportFatalException was called
[Command Line Processor: Info] [6156/1] [2013-02-04 12:53:04]: Exception: Access Database was not found by name 'Test_Access_Database'
 site: System.Collections.Generic.List`1[Microsoft.SSMA.Framework.Generic.XTree.XNode] SearchInMetabase(Microsoft.SSMA.Framework.Generic.Collectors.XMetabase, Microsoft.SSMA.Framework.Generic.SqlBase.CompoundObjectPath, Microsoft.SSMA.Framework.Generic.SSMAWorkspace.DefaultSSMAWorkspace)
 source: SSMAforAccessConsole
   at Microsoft.SSMA.GUI.Access2SqlServer.CommandProcessor.CommandProcessors.ObjectSearchHelper.SearchInMetabase(XMetabase metabase, CompoundObjectPath objectPath, DefaultSSMAWorkspace workspace)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.SchemaMappingAbstractProcessor.ProcessCommandImpl(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.CommandAbstractProcessor.ProcessCommand(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommand(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandSequence(XNode commandList)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandFile(String scriptFile, String serversFile, List`1 variableFiles, Int32& exitCode)
[Command Line Processor: Error] [6156/1] [2013-02-04 12:53:04]: ## ERROR: Access Database was not found by name 'Test_Access_Database'
[Command Line Processor: Error] [6156/1] [2013-02-04 12:53:04]: Exception: Access Database was not found by name 'Test_Access_Database'

 site: System.Collections.Generic.List`1[Microsoft.SSMA.Framework.Generic.XTree.XNode] SearchInMetabase(Microsoft.SSMA.Framework.Generic.Collectors.XMetabase, Microsoft.SSMA.Framework.Generic.SqlBase.CompoundObjectPath, Microsoft.SSMA.Framework.Generic.SSMAWorkspace.DefaultSSMAWorkspace)
 source: SSMAforAccessConsole
   at Microsoft.SSMA.GUI.Access2SqlServer.CommandProcessor.CommandProcessors.ObjectSearchHelper.SearchInMetabase(XMetabase metabase, CompoundObjectPath objectPath, DefaultSSMAWorkspace workspace)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.SchemaMappingAbstractProcessor.ProcessCommandImpl(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.CommandProcessors.CommandAbstractProcessor.ProcessCommand(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommand(XNode command)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandSequence(XNode commandList)
   at Microsoft.SSMA.GUI.Generic.CommandProcessor.AbstractCommandProcessor.ProcessCommandFile(String scriptFile, String serversFile, List`1 variableFiles, Int32& exitCode)
[Generic: Error] [6156/3] [2013-02-04 12:53:04]: Exception: The remote server returned an error: (407) Proxy Authentication Required.
 site: System.Net.WebResponse GetResponse()
 source: System
   at System.Net.HttpWebRequest.GetResponse()
   at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload()
[Generic: Error] [6156/1] [2013-02-04 12:53:05]: Exception: The remote server returned an error: (407) Proxy Authentication Required.
 site: System.Net.WebResponse GetResponse()
 source: System
   at System.Net.HttpWebRequest.GetResponse()
   at Microsoft.SSMA.Framework.Generic.SQM.SqmFileUploader.DoUpload()

System Specs:

Windows 7 (64 bit)

Microsoft Office 2010

Microsoft SQL Server 2008

Microsoft SQL Server Migration Assistant v5.2.1257

If you need any further information I will gladly supply it.

All tips, help, and assistance are appreciated.

Thank you for your valued time.

Answer 1

Hello,

Please try to contact SSMA support team at the following email address:

[e-mail]  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

I will do that, and post my findings so that it may be useful to others.

Answer 3

Hello,

Thank you in advance.

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

I'm in a similar situation, but can't get past the vague error "FATALERR Invalid argument used".

Anyway, as to your code, in your variables.xml file I would have done the following:

   <variable name="$AccessDatabase$" value="Test_Access_Database"/>
   <variable name="$AccessDatabaseFile$" value="$AccessDatabase$.mdb"/>

The changes are:

1. remove the .mdb extension in the first line; and
2. change .accdb to .mdb in the second line.

I'm not suggesting I'm correct and you're not, but my suggested changes seem to me to be a possible solution.

Nevertheless, the error message seems to be ignoring file extensions anyway, so maybe its a red herring.

Edit: I finally got mine to run - in my variables script I use the same construction as suggested in my post, so maybe it is the solution ...

Answer 5

Those lines are actually the default settings (short of the file name) that come with the sample. I did find it strange, as well, that they had placed an .accdb as the extension. I will attempt your change now as it does seem the logical solution. I am glad to hear it worked for you.

Edit: That was it -- a simple, logical solution. I do see where I was confused in setting up the variable... The added .accdb extension in the sample file did not help the confusion. Thank you, blackvan, that was very helpful.