TestComponents looking for dll?

[minoseah629]

Hello John,

I did a google search and found your talk about ssisunit. Good video.

My team has been using SSIS packages more and more. As a tester, your tool would help my team to test their ssis process.

I am currently using Visual Studio 2019 on Windows 10 x64

I pulled your repo down since I couldnt find a release to download and I was trying to build locally. When I tried to build, I got a several build errors (46) on ssisunit.testcomponent class library.

• DTSLib
• Microsoft.SqlServer.DTSPipelineWrap
• Microsoft.SqlServer.DTSRuntimewrap
• Microsoft.SqlServer.Pipelinehost

Doing some google search, I found updates to the dll folder locations:

C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSRuntimeWrap\v4.0_15.0.0.0__89845dcd8080cc91
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.DTSPipelineWrap\v4.0_15.0.0.0__89845dcd8080cc91
C:\Windows\Microsoft.NET\assembly\GAC_MSIL\Microsoft.SqlServer.PipelineHost\v4.0_15.0.0.0__89845dcd8080cc91\Microsoft.SQLServer.PipelineHost.dll

Couldnt seem to find dtslib.

But when I tried to compile, the .net framework version was 2.0 instead of 4.0 as the above dll targetted.

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-programming-overview?view=sql-server-ver15

[johnwelch]

I'm not sure which .csproj or solution you are referencing - but you should be using the 2017 one. I haven't upgraded this specifically for the latest versions of SSIS and .NET, but that version should get you started.