An issue occurred in Data Stewardship Platform (DSP®) versions previous to 6.7 that caused an error when trying to build SSIS packages using ODBC data source types. To remedy this, a dedicated ODBC connection object has been created and users can successfully build SSIS packages with the DSP configured in either 32-bit or 64-bit mode. However, users must ensure correct configuration of the DSP application server for SSIS packages to build and refresh successfully.
This article includes information on:
- How to configure the DSP application server for 32-bit mode.
- How to configure the DSP application server for 64-bit mode.
- How to check the PATH variable on the DSP application server.
- How to change the PATH variable on the DSP application server.
- What to do if you are still having issues.
Our support team is happy to help you resolve them. To expedite your issue diagnosis, include the following information in your support ticket:
Check the Path Value in System Administration
- Ensure that the Path value is correctly set on the Vertical View of the DataGarage_SSIS_FilePath record on the Admin > Data Sources page. It should look something like this:
- Make sure the folder exists on the DSP application server and has granted modify permissions to the following users:
- LOCAL SERVICE
- NETWORK SERVICE
Check the SSIS Version
To check the SSIS version:
- Open the DSP application server remote desktop.
- Navigate to the Control Panel > Administrative Tools > Services console.
- Sort by Name.
- Scroll down to SQL Server Integration Services.
If you take a screenshot, include the following:
- An expanded Name column so the number at the end can be seen.
- The Status, to determine whether or not SSIS is running.
If you are still having issues and need additional diagnostics, create a Collect debug log and send it to our support team. Refer to [Common] Generating DSP Debug Logs in the Knowledge Base for more information.