title: DacFx and Custom DeploymentContributor (AgileSqlClub.DeploymentFilterContributor)
body: <p>I've tried at least a dozen or so ways to get the module to load and work but still get the same error: </p>
  <p><em>Error SQL0: Required contributor with id 'AgileSqlClub.DeploymentFilterContributor' could not be loaded.</em></p>
  <p>I've tried to run it with DacFax/SqlPackage 150 (x64) and 140 (Both x86 and x64).
  All iterations of SqlPackage command attempted:</p>
  <ol>
  <li><p><strong>Full Path to DLL 150 DacFx</strong> </p>
  <p>&quot;C:\Program Files\Microsoft SQL Server\150\DAC\bin\sqlpackage.exe&quot; /a:Publish /SourceFile:C:\work\somedb.dacpac /TargetConnectionString:&quot;Server=tcp:somedb.database.windows.net,1433;&quot; /p:ExcludeObjectTypes=&quot;Users;Permissions;Logins;RoleMembership&quot; /p:VerifyDeployment=False /p:AllowIncompatiblePlatform=True /p:TreatVerificationErrorsAsWarnings=True /p:AdditionalDeploymentContributorPaths=&quot;C:\Program Files\Microsoft SQL Server\150\DAC\bin\Extensions\AgileSqlClub.SqlPackageFilter.dll&quot; /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments=&quot;SqlPackageFilter0=IgnoreName(.PainInTheRearFunction.)&quot;</p>
  </li>
  <li><p><strong>Full Path to Dir w DLL 150 DacFx</strong> </p>
  <p>&quot;C:\Program Files\Microsoft SQL Server\150\DAC\bin\sqlpackage.exe&quot; /a:Publish /SourceFile:C:\work\somedb.dacpac /TargetConnectionString:&quot;Server=tcp:somedb.database.windows.net,1433;&quot; /p:ExcludeObjectTypes=&quot;Users;Permissions;Logins;RoleMembership&quot; /p:VerifyDeployment=False /p:AllowIncompatiblePlatform=True /p:TreatVerificationErrorsAsWarnings=True /p:AdditionalDeploymentContributorPaths=&quot;C:\Program Files\Microsoft SQL Server\150\DAC\bin\Extensions&quot; /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments=&quot;SqlPackageFilter0=IgnoreName(.PainInTheRearFunction.)&quot; </p>
  </li>
  <li><p><strong>No Path 150 DacFx</strong>   </p>
  <p>&quot;C:\Program Files\Microsoft SQL Server\150\DAC\bin\sqlpackage.exe&quot; /a:Publish /SourceFile::C:\work\somedb.dacpac /TargetConnectionString:&quot;Server=tcp:somedb.database.windows.net,1433;&quot; /p:ExcludeObjectTypes=&quot;Users;Permissions;Logins;RoleMembership&quot; /p:VerifyDeployment=False /p:AllowIncompatiblePlatform=True /p:TreatVerificationErrorsAsWarnings=True /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments=&quot;SqlPackageFilter0=IgnoreName(.PainInTheRearFunction.)&quot;</p>
  </li>
  <li><p><strong>140 DacFx x86 (Doesn't support Additional Path Argument)</strong> </p>
  <p>&quot;C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe&quot; /a:Publish /SourceFile:C:\work\somedb.dacpac /TargetConnectionString:&quot;tcp:somedb.database.windows.net,1433;&quot; /p:ExcludeObjectTypes=&quot;Users;Permissions;Logins;RoleMembership&quot; /p:VerifyDeployment=False /p:AllowIncompatiblePlatform=True /p:TreatVerificationErrorsAsWarnings=True  /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments=&quot;SqlPackageFilter0=IgnoreName(.PainInTheRearFunction.)&quot;</p>
  </li>
  <li><p><strong>140 DacFx x64 (Doesn't support Additional Path Argument)</strong> </p>
  <p>&quot;C:\Program Files\Microsoft SQL Server\140\DAC\bin\sqlpackage.exe&quot; /a:Publish /SourceFile:C:\work\somedb.dacpac /TargetConnectionString:&quot; tcp:somedb.database.windows.net,1433;&quot; /p:ExcludeObjectTypes=&quot;Users;Permissions;Logins;RoleMembership&quot; /p:VerifyDeployment=False /p:AllowIncompatiblePlatform=True /p:TreatVerificationErrorsAsWarnings=True  /p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentFilterContributor /p:AdditionalDeploymentContributorArguments=&quot;SqlPackageFilter0=IgnoreName(. PainInTheRearFunction.)&quot;</p>
  </li>
  </ol>
  <p>Where I've tried to put the dll and pdb file:</p>
  <ul>
  <li>C:\Program Files\Microsoft SQL Server\150\DAC\bin</li>
  <li>C:\Program Files\Microsoft SQL Server\150\DAC\bin\Extensions</li>
  <li>C:\Program Files\Microsoft SQL Server\150\DAC\bin\Extensions\AgileSqlClub.DeploymentFilterContributor</li>
  <li>C:\Program Files\Microsoft SQL Server\140\DAC\bin\</li>
  <li>C:\Program Files\Microsoft SQL Server\140\DAC\bin\Extensions</li>
  <li>C:\Program Files\Microsoft SQL Server\140\DAC\bin\Extension\AgileSqlClub.DeploymentFilterContributor</li>
  <li>C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\</li>
  <li>C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\Extensions</li>
  <li>C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\Extension\AgileSqlClub.DeploymentFilterContributor</li>
  <li>Same folder as dacpac (C:\work)</li>
  </ul>
  <p>I am using the release version of the AgileSqlClub Deployment Contributor downloaded in zip format from here:</p>
  <ul>
  <li><a href="https://github.com/GoEddie/DeploymentContributorFilterer/releases/tag/1.4.4.1" rel="nofollow noreferrer">https://github.com/GoEddie/DeploymentContributorFilterer/releases/tag/1.4.4.1</a></li>
  <li>Zip contains 2 files:</li>
  <li>AgileSqlClub.SqlPackageFilter.dll</li>
  <li>AgileSqlClub.SqlPackageFilter.pdb</li>
  </ul>
  <p>I've read a dozen or so articles including:</p>
  <ul>
  <li><a href="https://stackoverflow.com/questions/34520446/sql-server-data-tools-error-loading-custom-deploymentplanmodifier-required-con">SQL Server Data Tools: Error loading custom DeploymentPlanModifier: Required contributor with id could not be loaded</a></li>
  <li><a href="https://dba.stackexchange.com/questions/268707/exclude-certain-schema-along-with-unnamed-constraints-in-ssdt">https://dba.stackexchange.com/questions/268707/exclude-certain-schema-along-with-unnamed-constraints-in-ssdt</a></li>
  <li><a href="https://the.agilesql.club/2015/01/howto-filter-dacpac-deployments/" rel="nofollow noreferrer">https://the.agilesql.club/2015/01/howto-filter-dacpac-deployments/</a></li>
  </ul>
  <p>I am not using SSDT just downloaded versions of DacFramework.msi (140/150)</p>
  <p>If I remove the DeploymentFilter arguments then SqlPackage loads everything but fails at the PainInTheRearFunction I am trying to filter and Ignore on.</p>
  <p>Any help would be greatly appreciated.</p>