Page 1 of 1

Create images from a SQLServer image data field

Posted: Fri May 27, 2005 10:11 am
by diegolenimois
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.

Posted: Fri May 27, 2005 10:39 am
by ArndW
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.