October 24, 2006 at 1:25 pm
Hello All
I am new to SQL Server and to this forum. I am trying to import data in from external sources. I have no problem with MS Access data. When i try to imprt data in from a DB2 db or an AS400 db i get an error. The error message is:
TITLE: SQL Server Import and Export Wizard------------------\------------
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (121).------------------------------
BUTTONS:
OK------------------------------
I am on a new server. My thought is that there are missing drivers on the server for DB2 or the proper as400 drivers.
Any thoughts??? Thanks in advance
Peter
October 24, 2006 at 5:47 pm
No need to cross-post. The regulars here watch the forums they know regularly.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 25, 2006 at 3:28 am
I'm just quoting pages, which say you need SSIS installed, and may need Service Pack 1. But if the problem still occurs, consider the adding to feedback issue report mentioned on the below page:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1&PageID=4
... Check whether you have "SQL Server Integration Services" service installed - its presence is reliable indicator of full SSIS install. If you don't have this service (and most likely you don't) - you don't have SSIS installed. ...
... "SP1 fixed this for me." ...
March 14, 2008 at 5:51 pm
Did you ever get a response to this question? I am having the same problem but just using a simple TEXT file as the import source, and get:
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - prc80312converted_txt" (1)
and
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (127)
on the same import session
March 17, 2008 at 6:59 am
i believe you dont have ssis installed on your local machine....when install sql server 2005 on your machine i guess u havent checked thssis box may be that would be the reason ...but its for sure that it hasnt been installed in ur local machine or may be it would be bcoz of service pack ...
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 17, 2008 at 8:01 am
Thanks. I have a server that has the full version installed (rather than my Vista version), and the Import task worked just fine. From my observations, if I did not have SSIS installed, I wouldn't have the TAST->import/export options available from the MSS tool.
I'll keep the post open tho. Thank you again. I will verify SSIS is installed.
March 17, 2008 at 8:09 am
If so try to do import using import/export in ssms ..if it went throuhg there might be some problem with ur ssis installation...as u said u are having vista could you just look at the service pack u have and jus download the supporting sp for that version...
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply