Error: Could Not Load File or Assembly 'Microsoft.SqlServer.DTSRuntimeWrap..

Symptoms

When deploying a SSIS package using the Jet Data Manager, an error similar to the following occurs:

" Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=XX.0.0.0, Culture=neutral, PublicKeyToken={token}' or one of its dependencies. The system cannot find the file specified."

" Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=XX.0.0.0, Culture=neutral, PublicKeyToken={token}' or one of its dependencies.  The system cannot find the file specified."

Cause

The cause of this error is either:

• SQL Server Integration Services is not installed on the local machine

Resolution

First, 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.

Alternatively, you can disable SSIS and the Jet Data Manager will default to using ado.net.