I receive unhelpful errors from attempting to import a ms access table into sql server 2005 using the import wizard. Here is the 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 "Data Conversion 1" (73).
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [Company].[dbo].[EMPLOYEE] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
I received this type of error once before and got around it by removing all constraints from the table. I was able to import the table when the data types were nvarchar. I changed the data types to varchar and this occurred. How do I know what the message is specifically referring to or can I see more details of the import command. This is my first posting.
Charley,
Data conversion transformation requires SQL Server enterprise edition to be executed. see if this link provides more information
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=594086&SiteID=1
No comments:
Post a Comment