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=XXXXXXXXXXXXX' or one of its dependencies. The system cannot find the file specified.
at TimeXtender.DataManager.SSIS2012.SSISEngine2012.CreatePackage_DataMovement(IDataMovementSourceTable dataMovementSourceTable, IDataMovementDestinationTable dataMovementDestinationTable)
at TimeXtender.DataManager.StepTransferSSISDeploy.DoAbstractStep(StepHorizontalType horizontalType, DataSource dataSource)
Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=XX.0.0.0, Culture=neutral, PublicKeyToken=XXXXXXXXXXXXXXXX' or one of its dependencies. The system cannot find the file specified.
The cause of this error is either SQL Server Integration Services is not installed on the local machine or y ou are running a 64 bit operating system and a 64 bit edition of the Jet Data Manager, but have installed a 32 bit SQL Server Integration Services (possibly by mistake). Jet Data Manager is trying to use the 64 bit assemblies in order to create the SSIS packages, but they are not present.
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. While here, m ake sure that the bit-versions match between your operating system and SSIS.