I'm trying to move a column from a MS Access 2000 database to a
table
on ASE 12. The column is a photo and is described as type OLE Object
in
Access. I have tried these methods:
1. When I create the pipeline the source datatype is BigBinary for
this
column. Whenever I try to run the pipeline I get the message:
'Select error. Column lists do not match'.
I have tried having the destination column of type binary, varbinary
and
image.
2. Writing PowerScript and using SelectBlob. When I use SelectBlob
on the MS Access photo column, PB blows up.
How can I transfer this data?
Thanks