I am trying to QODBC inside an SQL Server Integration Services (SSIS) package to import data into SQL Server for Advanced Reporting.

When I use Visual Studio to create the Package and test the script it works great.  When I put the package into the SQL Server Agent (SQL 2005) for automatic scheduling it fails with an error:

OnError,MARK-W2K,NT AUTHORITY\SYSTEM,ImportCustomersFromQuickBooks,{27833265-20F8-4C5C-98AF-2E89A57531D4},{CC298BB4-EFF0-4A77-89BF-E1CF7D30FF06},10/22/2007 1:49:21 PM,10/22/2007 1:49:21 PM,-1073450910,0x,System.Data.Odbc.OdbcException: ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.

ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)
OnError,MARK-W2K,NT AUTHORITY\SYSTEM,ImportCustomersFromQuickBooks,{27833265-20F8-4C5C-98AF-2E89A57531D4},{CC298BB4-EFF0-4A77-89BF-E1CF7D30FF06},10/22/2007 1:49:21 PM,10/22/2007 1:49:21 PM,-1073450985,0x,component "Source - Query" (1) failed validation and returned error code 0x80131937.