March 18, 2008 at 12:46 pm
I am getting a lot of DTS_E_PRODUCTLEVELTOLOW errors when trying to execute an SSIS package via Integration Services from SQL Server 2005 SP2.
The datbases are all in Compatibility mode 8.0 (SQL 2000) the DBs compatibility cannot be changed.
Can SSIS packages run under Intergration Services with 8.0 DBs? I am thinking no...
What about Integration Services as File System?
JTS
March 18, 2008 at 12:53 pm
I believe that their compatibilities should be consistent.
March 18, 2008 at 1:28 pm
If that is the case why would I get this message:
Error:SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is
insufficient for component "Data Conversion (cleared_amt)"(1422)
Error:SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is
insufficient for component "Flat File Source"(1)
Error:SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is
insufficient for component "Data Conversion (pmt_ref_nbr)"(1696)
In my package I am doing a Flat File import, Derived column task, copy column task into a DB with 8.0 compatibility
March 20, 2008 at 10:26 am
the error shows that ssis is not installed completely or a service pack is not updated accorfnig to the version ur using ...plz check that u shall get it
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 21, 2008 at 8:25 am
Thanks and just to confirm, the SQL server has a build number of SP2 plus a query hot fix.
Is it possible the application of the SP2 didn't patch the SSIS on the server?
Is there a way to see if SSIS is install on the SQL server installation?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply