Solved

I was importing data from Excel to SQL 2005

Posted on 2007-12-02
3
2,227 Views
Last Modified: 2012-06-21
I was importing data from Excel to SQL 2005 by using SQL Server Import and Export Wizard.
At the end of the last step, it gives me this error message:

- Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - Sheet1$" (1).
 (SQL Server Import and Export Wizard)


+++++++++++++Below are the complete Report:+++++++++++++++++++++++++++



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 [test].[dbo].[Sheet1$] (Stopped)

- Post-execute (Stopped)

- Cleanup (Stopped)

What do I do?
Thank you
0
Comment
Question by:erin027
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
imitchie earned 175 total points
ID: 20393544
0
 
LVL 25

Assisted Solution

by:imitchie
imitchie earned 175 total points
ID: 20393547
text from the link:

Solution: Install SP1 for SQL Server 2005 on the client machine. This will update the import files and the error will go away.

If the error does not go away, here is a great site on Microsofts MSDN site that discusses this error:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1
0
 
LVL 7

Assisted Solution

by:macentrap
macentrap earned 75 total points
ID: 20393557
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question