I am running SQL Server 2005 on Windows 2003. I ran the following statement
and returned the following:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
PRODUCTVERSION = 9.00.2153.00
PRODUCTLEVEL = SP1
EDITION = Enterprise Edition

I am attempting to export to a flat file from Management Studio by right
clicking on the database, then selecting "Export". I navigate through the Export wizard and click "Finish" to perform the export and receive the following
error:
"Error 0xc00470fe: Data Flow Task: The product level is insufficient for
component..."

I have SSIS installed.
I have Workstation components installed.

Just to be sure I tried adding/reinstalling these (SSIS and Workstation
components) components and was told by the setup routine that they are
already installed, that the features cannot be installed or upgraded since no
effective change is being made.

I have read in your forum and elsewhere that SP1 is a fix. Well, I am running
SP1 and it is not fixed.

I have read of workarounds, such as exporting to Access or Excel instead.

While those workarounds are fine, they still do not address the issue, or do
not resolve the problem of not being able to export to a flat file.

Is their a resolution to this issue that has been posted, which I am yet to
find, or is this going to be resolved in a hotfix or service pack?

Check whetherhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1 is any help.

---

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

Thanks Satya. The answer was found within the link you sent.

In my case, when I received the error "Product level is insufficient for component...", I opened Management Studio, connecting to a SQL 2005 database that had SSIS installed, but the machine I logged in to [the client] and opened Management Studio to make the connection to SQL 2005, did not have SSIS installed.

When I logged on directly to the server that contained the SQL 2005 database, opening Management Studio and performing the export, the export succeeded.

In summary:
I got the error "Product level is insufficient for component..." when logged on to a client that did not have Integration Services [SSIS] installed.

quote:

---

Originally posted by satya

Check whetherhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1 is any help.

---

Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),

SERVERPROPERTY ('edition')

PRODUCTVERSION = 8.00.760

PRODUCTLEVEL = SP3

EDITION = Standard Edition

still it is giving error while iporting an excel file . pls tell me wht to do now