Data Profile Viewer - Could not load file or assembly Microsoft.DataTransformationServices.ScaleHelper

Question

Hi!

I am new to SSIS. I downloaded and installed the development version of SQL Server for development. I have the latest update of Visual Studio 2019. I also have the newest version of SSIS projects. I'm trying to create a Data Profiling Task. Everything is configured correctly, and it runs to completion. However, when trying to preview the task, I get the following error message. A quick Google search only yielded two pages of results, none of which addressed the issue. Any suggestions in resolving this would be appreciated.

Cynthia

Answer 1

Hi @Cynthia McMahon ,

I could re-produce the issue locally.

Try to add following code to DataProfileViewer.exe.config.

Location: C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn

<dependentAssembly>  
<assemblyIdentity   
name="Microsoft.DataTransformationServices.ScaleHelper"   
publicKeyToken="89845dcd8080cc91" culture="neutral"/>  
<bindingRedirect oldVersion="15.0.0.0" newVersion="15.100.0.0"/>  
</dependentAssembly>  

Don't forget to backup DataProfileViewer.exe.config file.

And then restart VS2019, this helps to resolve my issue, hope it could be useful.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

Hi Zoe,

Thank you so much! This has fixed the problem.

Regards,
Cynthia