Problem Description:

I am trying to connect to QuickBooks through SSIS using QODBC, but I cannot link to QuickBooks.

I have a Read Only Desktop edition of QODBC, which is included with QuickBooks Enterprise Edition.

I am getting the error:

"Error = 80040408, Could not start QuickBooks."

Solution:

QODBC comes from QuickBooks Enterprise, is a read-only edition, and can only work with QuickBooks Enterprise.

But to work with SSIS, you need to use QRemote.

Please refer: To how to use QRemote.

Please refer: How to create a Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote.

Please note SSIS package is running as a Service (SQL Server is a service-based application).

If that's the case, you may have to use QRemote or DCOM. ( both require QODBC Server Edition License)

Please note QODBC Read-only edition for QuickBooks Enterprise does not include QRemote License.

Please refer: QODBC Licensing Information