"product level is insufficient" message during flat file import

"product level is insufficient" message during flat file import

• rumblespaul

  I would really like to see this available as a hotfix before a service pack.  Our company does a lot of data loading utilizing the Import/Export wizard and this issue will prevent us from upgrading to SQL Server 2005.
  
  Sean Carpenter
  

• BNavas

  If this is blocking your move to 2005, you should consider opening a case with customer support, reviewing with them the content of this thread, and pressing for the hotfix.
  
  With few exceptions, hotfixes are issued in response to escalated customer support calls.
  
  jkh

  
  
  

• Jaap de Wolff

  I got around the problem (hope I haven't created any others) by uninstalling Enterprise Edition and installing Developer Edition which allows all installation options.  I added IS to the install and then successfully ran the import/export wizard.
  

• Dr Cube

  We are having the same problem, only we get it on the server that SQL is installed on.  We are running the 64bit RTM version downloaded from MSDN, with all options installed.  I get the same errors, if I try to import from Excel, csv and sometimes from other tables on the same 2005 database.  This last one is only sometimes.
  
  CJ
  

• Andrew Law

  I ran into the same thing in September CTP with an attempted import of an Excel 2003 spreadsheet.  I had installed SSIS and was consistently running numerous fairly sophisticated ETL packages between MSSQL Server 2005, MSSQL Server 2000, Oracle and other sources.  It does not appear that the error is related to SSIS not being installed.
  
  Thanks.
  
  
  

  
  

• Sekar00

  I also get this error with the RTM release of Management Studio.  It seems ridiculous that the Import/Export wizard can't be run on a machine with just the workstation tools installed.  I really don't want to install Developer Edition on all of the machines here.  Is there no other workaround   Import/Export seems to be a natural function of a client-only installation.
  
  Sean Carpenter
  

• The Fluffster

  We've reconsidered this issue, and will be providing a fix for SP1 release.

  For now, you need to install SSIS to run the package in the wizard.

  
  
  

• TheUaRT

  Please see this thread:
  http://forums.microsoft.com/msdn/ShowPost.aspx PostID=110020
  
  SSIS ships as part of SQL 2005, but the setup give you a choice of whether to install it or not.
  
  Please rerun the setup. In one of the first screens the setup program asks which components to installs, there are 5 checkboxes total: SQL/SSAS/SSRS/SSIS and Workstation components. Please make sure the SSIS check box is checked.

  
  
  

• GillBates

  Thanks for reporting this problem, it seems like we have a bug here.
  
  Some components of SSIS (e.g. designer) are installed and work with 'Workstation Components' install. Other components of SSIS (e.g. service, dtexec, and dtexecui) require installation of 'Integration Services'.
  
  In current build the wizard can't execute the package it created without 'Integration Services' installation, which for Enterprise Edition means you need Server OS. You can still save the package and run or schedule it on machine with SSIS installed.
  
  We will fix this problem for SP1 release, the wizard should be able to run the package with just 'Workstation Components' install. Unfortunately, we missed this problem.
  
  Thanks,
  Michael.

  
  
  

• Gaudos

  And BTW - I immediately got it to work after importing the sheet into MS Access, and then using MS Access as the import source for MSSQL Server 2005 ...
  
  Thanks.
  

• killerless

  Damien, your problem is completely unrelated to "product level" issue. I would suggest starting another thread specific to your issue, so that someone who knows this area might notice and help.
  
  

• Alan Shields

  "Integration Services" is greyed-out as an installation option, I'm guessing, because I'm running XP.  It seems odd that I can install Management Studio but cannot use the import-export wizard.  Is this right   IS is not considered to be a "client tool" which the documentation says can be installed on XP
  

• Petru Moldovan

  I too am experiencing this same problem.  I am using the standard version of SQL Server Management Studio that I obtained for free at the SQL Server 2005 launch party in San Francisco.  I am running Windows XP.  I have tried to migrate tables from  my remote SQL Server 2000 DB without success.  Exporting to Access was successful, but when I import to the new DB I get the following errors:
  
  - Pre-execute (Error)
  Messages
  Error 0xc0202009: Data Flow Task: An OLE DB error has occurred. Error code: 0x80040E21.
  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E21  Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
   (SQL Server Import and Export Wizard)
   
  Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
   (SQL Server Import and Export Wizard)
   
  Error 0xc004701a: Data Flow Task: component "Destination - flo_layouts" (46) failed the pre-execute phase and returned error code 0xC0202025.
   (SQL Server Import and Export Wizard)
  
  I just wanted to weigh in and say that it would seem like this would be important enough for a quick 'hotfix'.  Ease of migration using these tools is by far the most important reason I switched from MySQL to SQL Server and with these functions not working it is a real bummer.
  
  Can anyone suggest a temporary work-aruond
  
  -Damien
  
  
  

• doyoucy

  I'm getting this same error when using the RTM release of the SQL Management Studio Import wizard to import data from Excel into SQL 2000. Does anyone know how to fix this
  
  
  TITLE: SQL Server Import and Export Wizard
  ------------------------------
  Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - AgentDirectoryDownload$" (1).

   

  
  
  
• "product level is insufficient" message during flat file import