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 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy