Thanks for your forum post. It seems you have run into a compatibility issue that is going to require you to make two different packages, one for SQL 2000 and one for 2005.
SQL Packager will produce SQL syntax compatible with the database being packaged -- it does not conditionally modify the SQL syntax at runtime. In your case, the problem is that the level0type of the extended property being executed is 'SCHEMA
' and SQL 2000 only understands this as 'USER
'. So if you were to change the failing query text from SCHEMA to USER, the query would succeed.
However, it may be better to produce a SQL 2000-compatible package anyway because other syntax problems could arise. To see how to produce a SQL 2000-compatible package from a SQL 2005 database, please reference the following knowledge base article:
http://www.red-gate.com/supportcenter/C ... 000150.htm
Hopefully this helps.