DB2 Write Image to Blob field

I need some help in SSIS Package I am trying to write a byte array to an image (blob) in DB2 destination. I am getting SQL code -290 Invalid Description, if i set the output column to a byte stream. If I set the output column to an Image data type then I get a different error the package will not at that time even process it errors out right away. At least using a byte stream datatype it errors out when it is about to write to the olebd destination. Anybody have success using BLOB fields in SSIS package data flow? Thanks for any help.

What provider you used for DB2? I have a memory that the Microsoft OLEDB provider for DB2 does not support retrieve LOB type columns, inside SSIS, yet. Please confirm with the version release note you installed on your computer if that's what you used.

thanks

wenyang

|||Are you using IBM DB2 .NET Data Provider? If not, get it as part of the IBM DB2 Clinet from https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?lang=en_US&source=swg-dm-db2client|||

Wenyang Hu wrote:

What provider you used for DB2? I have a memory that the Microsoft OLEDB provider for DB2 does not support retrieve LOB type columns, inside SSIS, yet. Please confirm with the version release note you installed on your computer if that's what you used.

thanks

wenyang

Do you know when this will be fixed?|||I am using the Microsoft OLE DB provider for DB2, I am not using the .net version.

db url to image

Hi All, I am pretty new to reporting services, but i have question regarding how to display an image when i pull the url from a database. I cannot seem to figure out how to do it and it seems pretty simple. If anyone has any ideas please let me know.

Thanks so much

josh

Josh..

Set the source in the report as external and the mime type depending on whatever file it is.

Regards

Karen

|||

Hi Josh,

For that you can set the value property of Image to that field (ie: field which contain url) and the source property to External.If its a picture from a folder/directory(local) add like

"file://"+Fields!Picture.Value

Thanks,

Sonu