April 21, 2011 at 12:53 pm
Hi,
I made a data import (from sql 2000 to sql 2005) ssis package in sql server 2005.
When I run that, i get error :-
SSIS Error code DTS_E_Productleveltolow. The product level is insufficient for component "data conversion 1"
The version of sql server I am using is:-
9.00.4035.00 SP3 Enterprise Edition
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 21, 2011 at 2:21 pm
When I scheduled the SSIS package in sql agent job, and ran from there
the error came up different :--
Column 'Description' cannot convert between unicode and non unicode string data types...
WARNING :- The external metadata column collection is out of synchronization with the data source columns. The column 'Description' needs to be updated in the external metadata column collection
I note that the table is imported in the sql 2005 along with column names but the table values are empty, that is 0 rows.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
April 22, 2011 at 10:04 am
The first error is probably caused by using an old version of dtexec. This will happen if you have both the SQL 2000 and SQL 2005 client tools installed on your workstation and your %PATH% environment variable is set so that it finds the 2000 version first. I corrected this on my machine by updating the %PATH% settings so that it found the 2005 version first.
The second error results from one of your fields being defined as WSTR (the default) and your destination being varchar. You can fix this by changing your source field to STR, creating a derived field where you cast your source field to STR, or by changing your destination field to nvarchar.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply