Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2233
  • Last Modified:

I was importing data from Excel to SQL 2005

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
erin027
Asked:
erin027
  • 2
3 Solutions
 
imitchieCommented:
0
 
imitchieCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now