erin027
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.