February 22, 2010 at 12:28 am
Hi
when i am uploading any excel sheet into sql server 2005 it always getting error of this messgae :Error 0XC00470fe: Data Flow Task: The Product level is insuffcient for component "Source- Sheet1@"(1).
what can i do...
February 22, 2010 at 12:38 am
fire
select @@version
and post the output here
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 22, 2010 at 12:43 am
Read this thread.
February 22, 2010 at 2:14 am
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [Create].[dbo].[Sheet1$] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
February 22, 2010 at 2:28 am
Can you check data type and data in the columns you are moving.
Also try with the other xls with very few data.
Also do one more experiment like export a small table into xls, Open the xls and delete a few records and again import the xls into a new table.
This may help you to narrow down problem.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 22, 2010 at 3:50 am
I ALREADY TRIED WITH SOME SAMPLE DATA IN EXCEL SHEET..BUT IT IS ALWAYS COMING THE SAME ERROR...I CHANGED DATA TYPES ALSO RESULT IS SAME..
February 22, 2010 at 3:56 am
Raju,
Dont use complete sentence in CAPITAL letters. It shows that you are asking a question as shouting on others.
Correct it while you post next time.
Cheers,
- Win.
" Have a great day "
February 22, 2010 at 4:06 am
excel is in .xls or .xlsx ?
Rename the sheet to the table name and check if the same number of coulmns are there in the sheet as per table.
Check: SSIS installed ? SP 2 applied ?
Try installing Integration services. This will install the components required to import and export ...
Hope this adds some sense to your post....
Cheers,
- Win.
" Have a great day "
February 22, 2010 at 5:39 am
Try second suggestions....
export it to xls and delete a few rows and improt it again with different table and see if it works.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply