Excel Import Error & WMI Issues

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply