Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
skybvi
Posting Yak Master
193 Posts |
 Posted - 2011-04-21 : 14:53:42
|
| 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 EditionRegards,SushantDBAWest Indies |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-21 : 15:19:56
|
| Is SSIS (the service) installed on that server?--Gail ShawSQL Server MVP |
 |
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-04-21 : 15:43:50
|
| yes..there are other packages and maintenance plans also on that server wchih are running fine.Regards,SushantDBAWest Indies |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-21 : 16:20:05
|
| Are you executing the package from a job? From The development tool? p.s. Maint plans don't need SSIS. Check that SSIS is installed on the machine that the package is running on (not the one it's stored on)--Gail ShawSQL Server MVP |
|
|
|
skybvi
Posting Yak Master
193 Posts |
Posted - 2011-04-21 : 16:22:42
|
| When I scheduled the SSIS package in sql agent job, and ran from therethe 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 collectionI 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,SushantDBAWest Indies |
|
|
|
|
|
|
Product level to low