-1

I've deployed some SSIS projects to SSIS Server catalog, which everyone runs perfectly in the Visual Studio environment and can connect and retrieve data from NETSUITE using the ADO NET provider (Netsuite AnalyticsConnect Data Provider) but when I try to automate the package in the SSIS Server, the job doesn't run and give the error:

enter image description here

Is there a way to work around this? I am not having any other errors or something related when the connection is with the local SQL Server.

mkrieger1
  • 19,194
  • 5
  • 54
  • 65
Luis Jacobo
  • 97
  • 1
  • 14
  • Did you install ADO NET provider (Netsuite AnalyticsConnect Data Provider) on the SSIS run-time server? – Yitzhak Khabinsky Jul 13 '23 at 20:00
  • Did you register the driver NetSuite.SuiteAnalyticsConnect.dll file in the Global Assembly Cache on the SSIS run-time server? https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_3998994424.html#bridgehead_4599371108 – Yitzhak Khabinsky Jul 13 '23 at 20:01
  • actually can't believe that I miss register the driver .dll. Remembered that I done that in the another PC, where is the Visual Studio running. Thanks, please post this as your answer. – Luis Jacobo Jul 13 '23 at 20:13

1 Answers1

0

It is a two step process:

  1. Install ADO NET provider (Netsuite AnalyticsConnect Data Provider) on the SSIS run-time server.
  2. Register the driver NetSuite.SuiteAnalyticsConnect.dll file in the Global Assembly Cache on the SSIS run-time server.

For the reference: Connecting with the ADO.NET Data Provider

Yitzhak Khabinsky
  • 18,471
  • 2
  • 15
  • 21
  • 3. Ensure the package runs in a 32bit runtime if required by the NetSuite driver. https://stackoverflow.com/questions/11642410/is-there-a-way-to-run-a-ssis-package-in-32-bit-runtime-from-another-project-whic – David Browne - Microsoft Jul 13 '23 at 22:24