Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rankone
Starting Member
24 Posts |
 Posted - 2011-09-30 : 17:01:59
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-01 : 14:01:34
|
| seems like you're trying to import data from excel 2010 or some later version file which your integration engine does not supportI dont have much idea on WMI error. did you try using ACE provider------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
rankone
Starting Member
24 Posts |
Posted - 2011-10-02 : 18:42:59
|
| I took the data from an excel 2007 file & saved it into an excel 2003 workbook. So I doubt that's the problem. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 01:04:53
|
| you saved it as 2003 version right? is extension of file .xls?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rankone
Starting Member
24 Posts |
Posted - 2011-10-03 : 10:22:10
|
quote:
Originally posted by rankone
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).'
Yes it is in a .xls format |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 12:05:43
|
| oh ok..Sorry I missed it. then it should be possible using export import wizard. Between can you try manually doing this in ssis by creating a excel source and oledb destination------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Excel Import Error