Skip to main content

[Collect] SSIS Package Errors for "Non-SQL" Data Source Types

Caroline St.John
  • Updated

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:

32-Bit DSP

If you are running the DSP in 32-bit mode, check the PATH environment variable and perform the following on the DSP application server:

  • Move all the 32-bit folders before the 64-bit folders.
  • Ensure that "C:\Oracle Files\instantclient_12_2\" is in the PATH; it affects the background jobs performing the refresh.

64-Bit DSP

If you are running the DSP in 64-bit mode, check the PATH environment variable and perform the following on the DSP application server:

  • Move all the 64bit folders before the 32bit folders.
  • Ensure that "C:\Oracle Files\instantclient_12_2\" is in the PATH; it affects the background jobs performing the refresh. 

Find the PATH Variable on the DSP Application Server

To check your PATH variable:

  1. Open a command prompt on your DSP application server.
  2. Enter path.

To change the PATH variable (if needed):

  1. Make a remote desktop connection to the DSP application server.
  2. Search for and run Advanced System Settings.
  3. Click the Environment Variables... button.
  4. Highlight Path, and click the Edit... button in the System Variables pane. 
  5. Copy the Variable value text into a notepad.
  6. Edit the text as needed in the notepad.
  7. Copy the text back into the Variable value text, overwriting the previous text.
  8. Click OK, OK and OK.
NOTE: Once the PATH variable is updated, you may need to restart IIS (with iisreset in cmd)
and the CranSoft Service(s).  If that does not work, you may need to restart the DSP application sever. 

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

  1. 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:

    DataSources.png​

  2. Make sure the folder exists on the DSP application server and has granted modify permissions to the following users:
    • IUSR
    • IIS_IUSRS
    • LOCAL SERVICE
    • NETWORK SERVICE

Check the SSIS Version

To check the SSIS version:

  1. Open the DSP application server remote desktop.
  2. Navigate to the Control Panel > Administrative Tools > Services console.
  3. Sort by Name.
  4. 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.

Additional Diagnostics

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.

Related articles