Symptoms
When deploying and executing a table in the Jet Data Manager, the following error occurs:
"Error Creating DTS package for <table>. Exception from HRESULT: 0XC0048021"
Cause:
This error will occur when the Jet Data Manager is being used on one machine and the SSIS packages are being deployed to another machine.
Resolution
In order to resolve the issue, the Jet Data Manager needs to be installed on the same machine as the deployment target and used from that machine, or the use of SSIS packages needs to be disabled and ADO.NET used instead.
Comments