SQl: The product level is insufficient

Published by

Posted on May 23, 2008

Error 0xc00470fe: Data Flow Task: The product level is insufficient
for component “Source – test.txt” (1).
(SQL Server Import and Export Wizard)

The “The product level is insufficient” error means you are missing the SSIS Service. This can be resolved by reinstalling your local copy of SQL server or by installing Service Pack 2 for SQL server 2005. There is also a service pack release for Studio Management 2005.

You can find more information on SSIS at http://en.wikipedia.org/wiki/SQL_Server_Integration_Services

Studio Management 2005 SP2

SQL 2005 SP2

SQL express SP2

If you are using the Developer or Enterprise version you will be about to perform a search on Microsoft website for the service packs.