Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

errorDTSRuntime.png

" 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

mceclip0.png

Published:

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:

errorDTSRuntime.png

" 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

mceclip0.png

For an optimal Community experience, Please view on Desktop