Solved

I was importing data from Excel to SQL 2005

Posted on 2007-12-02
3
2,226 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

914 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now