<div>
is it a 64 bit sql2005 server ...
</div>


<div>
DantheDBA,<br />
<br />
Thanks. &nbsp;I did the SP2 update and now it works fine.<br />
<br />
GabicusC
</div>


DantheDBA,

Thanks.  I did the SP2 update and now it works fine.

GabicusC

<div>
I appears that it needs to be run under SQL Server 2005 with SSIS installed. Not on workstation, because workstation doesn't have license to run, unless it ran under BIDS. <br />
<br />
<a href="http://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition" rel="ugc">http://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition</a>
</div>


I appears that it needs to be run under SQL Server 2005 with SSIS installed. Not on workstation, because workstation doesn't have license to run, unless it ran under BIDS.

http://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition [http://connect.microsoft.com/SQLServer/feedback/details/217596/ssis-error-the-product-level-is-insufficient-for-component-w-enterprise-edition]

<div>
<div class="content wysiwyg-content">
I am trying to import information from a spreadsheet for the first time in SQL 2005. &nbsp;I have done this many times in SQL 2000 with no issues. &nbsp;But now I am getting the following errors and I am not sure where I need to start to fix it. &nbsp;The only thing I can think of is to change all the Data Types on the Spreadsheet. &nbsp;Any advice would be very helpful.<br />
<br />
Thanks,<br />
<br />
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component &quot;Source - Sheet1$&quot; (1).<br />
&nbsp;(SQL Server Import and Export Wizard)<br />
&nbsp;<br />
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component &quot;Data Conversion 1&quot; (126).<br />
&nbsp;(SQL Server Import and Export Wizard)<br />

</div>
</div>


I am trying to import information from a spreadsheet for the first time in SQL 2005.  I have done this many times in SQL 2000 with no issues.  But now I am getting the following errors and I am not sure where I need to start to fix it.  The only thing I can think of is to change all the Data Types on the Spreadsheet.  Any advice would be very helpful.

Thanks,

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
 (SQL Server Import and Export Wizard)
 
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (126).
 (SQL Server Import and Export Wizard)


The product level is insufficient for component error.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.