Okay, this works for SS2005. What exists to do the same kind of thing in SS2000?

Mike, one thing we've found in dealing with the MS and IBM OLE DB providers for DB2:  the MS provider doesn't support BLOB or CLOB columns.  The IBM does, but...

It does look like the IBM DB2 OLE DB provider does work with CLOBs and BLOBs.  And you can just put in your own info on the site to get...

Okay, gang, it just got worse.  Documentation on the MS OLEDB driver for DB2 says it doesn't support BLOB or CLOB data formats.  There's a forum string on MSDN suggesting using...

Okay, here's the conditions:

DB2 table with a BLOB column ALTERNATE_CATEGORY_MASK

Task settings:  I do have a specified directory for the BlobTempStoragePath

Data flow component Custom Properties for the DB2 link: 

AccessMode: OpenRowset

AlwaysUseDefaultCodePage:...

I'll give it a look as soon as I get the service pack for VS downloaded and run.  I'm on a new computer this morning, and I'm still getting it...

The output field in the SQL table is defined as a TEXT field.  All the errors are coming from the DB2 side of the data flow for the table. It looks like...

The error messages are:

Error: 0xC020901C at Set 5 1, DB2 VENDOR_MASTER 1 [243]: There was an error with output column "COMMENTS" (329) on output "OLE DB Source Output" (254)....

Mike, thanks, that got me past the timestamp schtick.  Now I'm having a problem with a DB2 CLOB column in the same freakin' table.  Any words of wisdom?

Okay, in the advanced editor on the DB2 OLE DB source, under Column Mappings tab, the External Column Type is DT-DBTIMESTAMP, Database-timestamp.  In Input and Output properties tab, says the...

Well, when I try selecting that value in the data conversion step as the output, I get the same error.

Right now I have three steps in the package:  the OLE...