Excel Import Error & WMI Issues

• Rank1_nj

  SSC-Addicted

  Points: 425

  More actions

  September 30, 2011 at 3:03 pm

  #248672

  Hey Everyone, I have been trying to import data from .xls files into tables in SQL SERVER 2005 but it keeps failing in the wizard on the validation part. The Error message I keep getting is

  ' Error 0xc00470fe: Data Flow Task: The product level is insufficent for component "Source - Sheet1$" (1).' I don't know what the cause of this is, but I tried installing SQL Server 2008 then in order to achieve the same task, & I kept getting a WMI (Windows Management Instrumentation) error when trying to install. I don't know if the errors are related, but I tried fixing the WMI by running several batch files & using the diagnostics but to no success. Does anyone have any insight on this?

  Thanks

• kyleheath33

  Ten Centuries

  Points: 1089

  More actions

  October 4, 2011 at 8:51 am

  #1390182

  Here is a link to what the error means:

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/

  Means that you are missing SSIS from the install. Can you check if that's the problem and let us know.