Full text indexing would be an option using the contains clause

SELECT ..... FROM SomeTable

WHERE CONTAINS(ColumnName, 'abc or def or ghi ....... ')

Yep, thats the documented way to do what you want to do.

I would completly re-write it all, for one all the tables used are depreciated and are in the product for SQL 2000 compatability only, you really should be using the...

SELECT

db.name,

db.create_date,

sum(mf.size*8) AS SizeInKB

FROM

sys.databases db

INNER JOIN

sys.master_files mf

ON

db.database_id = mf.database_id...

Don't update the system tables directly.

Instead use sp_update_job passing in the old name and the new name.

Strange as that would of been my first point to look at, as it seems to be the most logical.

Have you tried using a calculated column using a cast operator...

http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL%20Server&ProdVer=10.0&EvtID=12291&EvtSrc=SQLISPackage100&LCID=1033

Possible Causes

There are many possible causes for a package to stop running. This message might appear because of one of the following problems:

The data sources, files,...

Have you refreshed your data source view so that it picks up the new schema?

So many to choose from.

Brains (just because I was reading this, this morning http://www.dailymail.co.uk/news/article-2257951/Kentucky-Fried-Brain-Students-horror-finds-wrinkled-organ-inside-chicken-KFC-experts-insist-just-kidney.html)

That is a funny one, as the convert is the same in the select and the where, so both should fail.

Would it be possible to post the DDL (CREATE TABLE...

From the SQL website http://www.microsoft.com/sqlserver/en/us/solutions-technologies/mission-critical-operations/performance-and-scalability.aspx

Scale up and out across traditional server deployments and private and public cloud.

Deploy and Scale Out

Grow beyond the constraints of any one...

ERP - Enterprise Resource Planning, usually software like Microsoft Dynamics AX provide you with ERP.

ERP as usually a managament platform, for managing the day to day activities of the business,...

Unsure, not used the dtutil to export packages, always do it via SSMS as I find it easier.

There might be a switch to do it, I would check the MSDN...

international

When exporting from within SSMS, have you tried to change the protection level to Do Not Store Sensitive Data?