SQL Server Performance

Product level is insufficient for component

Discussion in 'SQL Server 2005 General DBA Questions' started by rerichards, Oct 5, 2006.

  1. rerichards New Member

    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?

  2. satya Moderator

  3. rerichards New Member

    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.
  4. amitperlsharma New Member

    SELECT
    SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),SERVERPROPERTY
    ('edition')PRODUCTVERSION = 8.00.760
    PRODUCTLEVEL
    = SP3EDITION
    = Standard Edition
    still it is giving error while iporting an excel file . pls tell me wht to do now

Share This Page