SSIS Error Code DTS_E_PRODUCTLEVELTOLOW
Hi all, I am receiving this error SSIS Error Code DTS_E_PRODUCTLEVELTOLOW for severl components when i attempt to run my packages. I have reviewed the other threads around this error and i can confirm that SSIS is intalled and running on the machine I am attempting run from - in fact, everything is running locally. Source and desitination databases are located on my default SQL server: Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6002: Service Pack 2) Integration Services were installed with my 2008 instance: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2) Integration Services version 10.0.1600 My integration services solution is an 05 solution - i have bids 05 and 08 installed. This is where i believe my issue lies - can i not run my 05 solution on 2008 IS server? These packages need to run on both 2008 and 2005. Do I need to create two solutions? Any assistance greatly appreciated. Thanks.
May 19th, 2011 7:34pm

I made a copy of my solution and upgraded to 2008. Problem solved. Was hoping i could deploy my 2005 packages to a 2008 ssis server. Apparently i will need to maintain two sets of packages... Any other suggestions?
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 8:07pm

SSIS 2008 packages can't be run of SQL Server 2005 however SSIS 2005 packages will run on SQL Server 2008. An important thing to note is that Visual Studio 2008 will be able to run SSIS 2005 packages. However, the moment you save the package in the designer or use the conversion tool, the package will be converted to SSIS 2008 format and will not be able to be used in Visual Studio 2005 or SQL Serve 2005 again.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
May 19th, 2011 8:07pm

Thanks Jeff, "SSIS 2005 packages will run on SQL Server 2008" - this was my understanding also. However, i am experiencing the opposite i.e. I am receiving the above message when i attempt to run my 2005 packages on a 2008 server. Note, the packages have not been deployed to the server, they are running from BIDS 2005. As it's all on the same machine (BIDS 05, SQL 05, SSIS 08) - i didn't think this would matter.
Free Windows Admin Tool Kit Click here and download it now
May 19th, 2011 9:56pm

You will need to update the SQL Native Client Connectivity (SNAC) to version 10. This is the provider used in your database connections and can be found in the Connection String Provider=SQLNCLI10.1Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
May 19th, 2011 10:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics