Connect QuickBooks to SQL Server through SSIS

  • Comments posted to this topic are about the item Connect QuickBooks to SQL Server through SSIS

  • nice informercial.

  • What VS and SQL Server versions does this require?

    Thanks,

  • It's a standard ADO.NET Data Source so you should be fine with 2005 or later

  • Thanks - I assume that to have that kind of "integration" project type in VS I need to have SSIS installed or configured or whatever? I've never looked at SSIS. Sounds like it could also be done (with more steps/code) just using QB as an Ado.Net data source?

  • Yes - you can use the RSSBus ADO.NET provider for QuickBooks as a standard ADO.NET Data Source with full CRUD support. If you use the Visual Studio designers there wouldn't even be any coding required. It's a standard ADO.NET source so you can easily bind to it from just about anything.

  • +1 on the infomercial reference. The article is nicely written, but what's the point of being misleading, the article implies that you can do it natively, not that you'll have to spend money. If you were going to spend money, you'd already know about this company and their product, and presumably would know how to implement it as well.

  • Jason, I'm not sure that I follow - the article is not in any way attempting to be misleading, nor does the fact that it is an article imply that the solution should be free. There are dozens of articles on the site that use commercial products to help solve data problems.

  • I never said attempting to be misleading, I said flat out misleading. The fact it is an article attempting to solve a solution to a community does imply the solution should be free, otherwise it should be labeled as an Ad. You're correct, dozens of articles do stump for commercial products, doesn't mean they are correct either. It's like googling for a solution to an issue and hitting experts-exchange and having to pay for an answer that is freely available in plenty of other forums.

    All that said, it was a very good explanation on how to use the product.

  • This was removed by the editor as SPAM

  • Very useful information for quickbooks support number.

  • jason.quackenbush - Wednesday, June 6, 2012 2:46 PM

    I never said attempting to be misleading, I said flat out misleading. The fact it is an article attempting to solve a solution to a community does imply the solution should be free, otherwise it should be labeled as an Ad. You're correct, dozens of articles do stump for commercial products, doesn't mean they are correct either. It's like googling for a solution to an issue and hitting experts-exchange and having to pay for an answer that is freely available in plenty of other forums.All that said, it was a very good explanation on how to use the product.

    I'll add one more complaint to that observation.  If you look at the article now, none of the graphics are visible.  This is because they didn't take the time to upload them to the article (as they should) and the links to the graphics are no longer available, although the company does still appear to be in business.

    Even if the article remained useful without the graphics, I'm not likely to go searching for the squirrel that buried the acorn.  Companies really should keep track of their own stuff on other forums if they actually do want some business from their infomercial instead of leaving aging piles of poo in someone's front yard. 😉

    Of course, Microsoft does the same thing with moving their links so fast and often that even current documentation has broken links.

    And, yeah... thumbs up on the "misleading" thing.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 12 posts - 1 through 12 (of 12 total)

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