question

CynthiaMcMahon-1606 avatar image
0 Votes"
CynthiaMcMahon-1606 asked CynthiaMcMahon-1606 answered

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

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

136425-capture.png


sql-server-integration-services
capture.png (36.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT edited

Hi @CynthiaMcMahon-1606,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CynthiaMcMahon-1606 avatar image
0 Votes"
CynthiaMcMahon-1606 answered

Hi Zoe,

Thank you so much! This has fixed the problem.

Regards,
Cynthia

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.