Thanks for your reply, this is a little different I think than dealing with excel outputs, these are actual binary files that from what I can tell the vendor has stored in the database as blobs, but the datatype is ntext in sql server and unicode text stream [DT_NTEXT] in ssis.

Take a look here for the process I followed to attempt this export:

http://books.google.com/books?id=i4gg8AqZHMoC&pg=PA159&lpg=PA159&dq=exporting+blobs+sql+server+2005&source=bl&ots=B0ialdUUgp&sig=z2OlNuOE-Mnlo9XiOyIayNdJ3gQ&hl=en&ei=E4OhSpbQC4WesgOtiv2MDw&sa=X&oi=book_result&ct=result&resnum=9#v=onepage&q=&f=false

An interesting twist I just found out, if you change the datatype on the external column for the OLE DB SOURCE to a [DT_BYTES] (varbinary datatype) the export column transformation doesn't see it as a blob any longer.

I'm so confused about how to procede with this my head hurts! 😉