Create images from a SQLServer image data field

diegolenimois · Post by **diegolenimois** » Fri May 27, 2005 10:11 am

Hello,

I have a table on SQLServer containing a field of type 'image'. I want to read from this field to create the corresponding image files. Is it possible to do that with DataStage?
If the answer is yes, please give me some advice on how to do this.

Thanks for your help.

ArndW · Post by **ArndW** » Fri May 27, 2005 10:39 am

DataStage doesn't have an image stage, it would just take this data (as a binary datatype) and pass it through to wherever you wish to send it. If you know the format of your image files, or if each entry in the "image" column is it's own file, then you could use DataStage to do this.