I'm trying to perform a one time backup of tables in Quickbooks Enterprise 7.0 to SQL Server 2005.  I have Quickbooks setup using QODBC as a Linked Server (Does QODBC work with MS SQL Server Linked Tables?), and I've tried the following:

Copying the tables using "Select * INTO <table> FROM QODBC...<table>".  Many of the table copy over fine, but I am getting the following error on a few of them: "An unexpected NULL value occured... Column can not be NULL".  I tried copying just the table structure over, removed the constraints on the copied table, and then performed an insert... but still got the same error.

I've also tried doing a bulk transfer using the following tutorial ( Using DTS to Load QuickBooks Data into Microsoft SQL Server).  This would be ideal since it isn't as much work as the above method, but it doesn't seam to be working with SQL Server 2005.  I updated the DTProperties to sysdiagrams, but I'm wondering if since I had a different version of quickbooks (different tables) that is causing some issues.

Please let me know if anyone has used the DTS bulk load with 2005, or how to by pass this constraint issue.  Thanks!!!!!!

Ok, the nulls are because of your optimizer settings, my recommended settings for using QODBC are shown here:

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for an explaination of all the options available to you. You will need to "Reload All Data" once you change the "For balances and stock quantities" setting to "Dirty Reads".