Published by exdone
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
If you are using the Developer or Enterprise version you will be about to perform a search on Microsoft website for the service packs.