April 29, 2008 at 1:41 pm
I would like to Import data from MS Access to a table SQL 2005.
The table does not exist before the import.
The data type in MS Access is TEXT.
The data type in the table of SQL 2005 to be created is nvarchar.
If I kept the data type in SQL 2005 unchanged, I can do it without any issue.
If I changed the data type from nvarchar to varchar (the length is not changed), I got the following error:
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (69).
Any input will be greatly appreciated in advance.
April 29, 2008 at 2:03 pm
You are trying to use a Data Conversion component on a server or workstation that does not have an SSIS server installed.
The computer EXECUTING the package (not the one it is stored on) needs to be of the appropriate SQL Edition to use specific components. Without being an SSIS server, the basic components for the wizards and for maintenance plans work, but to use anything else you need to be running the package from an SSIS server. From there, to use advanced transformations you need to be running the Enterprise Edition of SSIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply