Scott Roth · May 26, 2016

Microsoft SQL Image Column to JPG file using Ensemble

Has anyone tried to extract a Microsoft SQL Image Column into a JPG file using Ensemble? We currently have a Microsoft SQL Integration Services job that exports a SQL Image column into a JPG and then resizes it. I would like to get this job off of Microsoft so the rest of our team can support it and wondered if we could do it in Cache Object Script using Ensemble.



Scott Roth

The Ohio State University Wexner Medical Center

0 273
Discussion (1)1
Log in or sign up to continue

I don't have a complete answer for you, but presumably you could grab the binary stream via SQL and then save the stream do disk via the %Stream.FileBinary class interface.  We manage JPG files through that interface, but I haven't done the fetch via SQL before (so hopefully someone who has fetched a jpg via SQL could comment on that piece)