We have a package put together in SQL2005 BIDS. It runs fine there. However, upon deploying that package to our live environment and utilizing DTEXEC to call it from a command line we receive the 'product level is insufficient' error. We have recently upgraded to SQL2008 developer editions on our local machines (but not on our servers) and can see that Integration Services is running on the local instance. The package itself is very simple. It is comprised of several data flows which funnel information from our production server to a development server. Again, this works in BIDS but not from a command line. Anyone have any suggestions?

If you have upgraded your dtsx package to SQL 2008, you will have to get the SQL 2008 version of DTEXEC installed on the server. SQL 2005 DTEXEC cannot run a SQL 2008 package, no matter how simple it is. I know this hurts, I've felt the pain Craig Bryden - Please mark correct answers