ADO.NET error. Package runs fine in BIDS but fails as a SQL Server Agent job

  • Hello All,

    I am new to SQL Server management and I created a BIDS package that accesses QuickBooks and pulls data into Excel. The package runs fine in BIDS but when I run it through a SQL Server Agent job I get the following error:

    /> Source: Data Flow Task <nl/> Pre-Execute: 0% complete<nl/>End Progress<nl/>Error: 2012-10-18 16:05:06.80<nl/> Code: 0xC0047062<nl/> Source: Data Flow Task ADO NET Source [2]<nl/> Description: System.Data.RSSBus.QuickBooks.QuickBooksException (0x80004005): [500] Could not execute specified command: Could not start QuickBooks. (Possible solution: If QuickBooks is not running you must specify a CompanyFile.) ---> System.Exception: Could not start QuickBooks. (Possible solution: If QuickBooks is not running you must specify a CompanyFile.)

    For some reason it isn't able to get the data from QuickBooks because it doesn't see that it is open. Again, it works fine from BIDS. Anyone seen this same issue. Also, does anyone know the correct syntax within rssbus.quickbooks to specify the qbw file name?

    Thank you in advance.

    J

  • jefferyweeks 30481 (10/18/2012)


    Hello All,

    I am new to SQL Server management and I created a BIDS package that accesses QuickBooks and pulls data into Excel. The package runs fine in BIDS but when I run it through a SQL Server Agent job I get the following error:

    /> Source: Data Flow Task <nl/> Pre-Execute: 0% complete<nl/>End Progress<nl/>Error: 2012-10-18 16:05:06.80<nl/> Code: 0xC0047062<nl/> Source: Data Flow Task ADO NET Source [2]<nl/> Description: System.Data.RSSBus.QuickBooks.QuickBooksException (0x80004005): [500] Could not execute specified command: Could not start QuickBooks. (Possible solution: If QuickBooks is not running you must specify a CompanyFile.) ---> System.Exception: Could not start QuickBooks. (Possible solution: If QuickBooks is not running you must specify a CompanyFile.)

    For some reason it isn't able to get the data from QuickBooks because it doesn't see that it is open. Again, it works fine from BIDS. Anyone seen this same issue. Also, does anyone know the correct syntax within rssbus.quickbooks to specify the qbw file name?

    Thank you in advance.

    J

    I had a similar issue, then it dawned on me what the problem was. When running under BIDS, you are using YOUR account. When running as a job, your using the SQL Agent account. In order for that to work properly, you have to configure a proxy credential.

    A link I found useful:

  • Great. I will try that out. Thank you so much for the response!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply