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 support
I dont have much idea on WMI error. did you try using ACE provider
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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 MVP
http://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 MVP
http://visakhm.blogspot.com/
|
|
|
|
|
|
|
Excel Import Error