sql project can't load profile with connection string ending in ;

[anthonydresser]

example publish profile:

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <TargetDatabaseName>Database_Name</TargetDatabaseName>
    <DeployScriptFileName>Script.database.sql</DeployScriptFileName>
    <TargetConnectionString>Data Source=(LOCAL);Initial Catalog=NAMEOFDATABASE;User id=USER;Password=TYPEPASSWORDHERE;</TargetConnectionString>
    <ScriptDatabaseOptions>True</ScriptDatabaseOptions>
    <BlockIncrementalDeploymentIfDataLoss>False</BlockIncrementalDeploymentIfDataLoss>
    <PublishDependentProjects>False</PublishDependentProjects>
    <ProfileVersionNumber>1</ProfileVersionNumber>
    <SingleUserMode>False</SingleUserMode>
    <BlockOnPossibleDataLoss>False</BlockOnPossibleDataLoss>
    <DropObjectsNotInSource>False</DropObjectsNotInSource>
    <DropStatisticsNotInSource>False</DropStatisticsNotInSource>
    <DropExtendedPropertiesNotInSource>False</DropExtendedPropertiesNotInSource>
    <DropPermissionsNotInSource>False</DropPermissionsNotInSource>
    <DropRoleMembersNotInSource>False</DropRoleMembersNotInSource>
  </PropertyGroup>
</Project>

profile loads correctly if you remove the last semicolong before . The profile should still be able to load even if there's a semicolon there.