Prod level is insufficient for component 2

[gertNo1]

Hi Guys, I am relatively new to SQL Server. I am trying to export a file but I keep getting this msg:

 The product level is insufficient for component "data conversion 1" [69]

I dbl ck'd my field sizes and they all seem to be ok.
Any idea what this means?

Thanks so much

 

[mrdenny]

What are you doing when this error comes up?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[gertNo1]

Hi Denny thanx so much for responding.

I am trying to export a table. I tried exporting to Excel and then to Access. The process seems to be failing the validation step (from what I see in the Wizard).

Here is the error I am getting now:
Error 0xc00470fe
The product level is insufficient for component destination


Thanks again,

 

[SQLSister]

how big a table? What is the structure of the table (datatypes, etc?)

"NOTHING is more important in a database than integrity." ESquared

 

[mrdenny]

This is normal in SQL 2005 when exporting to Excel. To export or insert to Excel or Access you have to have the SSIS service installed on the machine. Try doing the export on the SQL 2005 server not your workstation (or install the SQL Server Integration Services on your workstation).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[gertNo1]

Thanks to all who responded I figured it out. DUH!