Microsoft.SQLServer.DTSRuntimeWrap.dll 64bit exists?

CPH1969 6 Reputation points
2021-09-29T16:13:09.87+00:00

Hi

I am using the Integration Services object model to 'programmatically' create SSIS packages dynamically on-the-fly.

The concept is described here and works fine using 32 bit components.

https://learn.microsoft.com/en-us/sql/integration-services/building-packages-programmatically/building-packages-programmatically?view=sql-server-ver15

However I'm getting the following error when trying to build the package in a 64 bit environment:
"There was a mismatch between the processor architecture of the project being built "MSIL" and the processor architecture of the reference "Microsoft.SQLServer.DTSRuntimeWrap"

This stems from my inability to find a complete set of the required 64bit dlls:

Microsoft.SqlServer.Dts.Design.dll
Microsoft.SQLServer.DTSPipelineWrap.dll
Microsoft.SqlServer.DTSRuntimeWrap.dll (I can only find the 32bit version)
Microsoft.SqlServer.ManagedDTS.dll
Microsoft.SQLServer.PipelineHost.dll

I'm beginning to wonder if a 64bit version of Microsoft.SqlServer.DTSRuntimeWrap.dll exists at all?

Does anyone know if and where it can be obtained?

Chris H

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
{count} vote

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2021-09-30T08:55:47.017+00:00

    Hi @CPH1969 ,

    Is it a warning or error message?

    I'm not familiar with script writing and did some research that someone always meet this type of warning in VS.

    You may take a reference below links to see if it is helpful.

    https://stackoverflow.com/questions/20741590/consuming-web-service-in-ssis-gives-mismatch-between-the-processor-architecture

    https://stackoverflow.com/questions/10113532/how-do-i-fix-the-visual-studio-compile-error-mismatch-between-processor-archit

    I have not found the 64bit dll as well until now.

    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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.