Symptoms

You receive the following error message:

Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, [...]' or one of it's dependencies. The system cannot find the file specified.

Cause

The cause of this error can be one of the following:

1. You have not installed SQL Server Integration Services.
2. You are running a 64 bit operating system and a 64 bit edition of TX, but have installed a 32 bit SQL Server Integration Services (possibly by mistake). TX is trying to use the 64 bit assemblies, but they are not present.

Resolution

Make sure that Integration Services is installed

You can verify that Integration Services is installed by going to Services (Start -> Run -> Services.msc -> OK) and locating the SQL Server Integration Services service and verify that it is running.

If the service is not present you need to install SQL Server Integration Services.

Make sure that the bit-versions match

You can use two approaches to detect whether this might be your problem:

1. Install TX in a 32 bit version and see if it deploys correctly
2. Execute this query against SQL Server: SELECT @@VERSION
   If the result looks like this it will indicate that there is a bit-version mismatch:
   

   Microsoft SQL Server 2012 - 11.0.2100.60 (X86)  Feb 10 2012 19:39:15  Copyright (c) Microsoft Corporation  Enterprise Edition on Windows NT 6.2 <X64> (Build 9200: )

   
   Note that SQL Server is 32-bit (the first X86 part) but Windows is 64-bit (the last X64 part).

If you have detected that is your problem, you can either use a 32-bit version of TX or reinstall a 64-bit version of SQL Server Integration Services.

This article applies to: tX2012, TX2014.