I have been tasked with creating an export from a mssql db which will contain
data and in addition have pictures filed in a directory. Is there a way in
tsql to convert these image data types to jpg files?

Assuming that the data that is stored in the database is the raw data for
the jpg image, you will need to write an application (or perhaps an extended
stored procedure) that will take the data from a query and write it out to a
file system as a jpg file. Actually it is not really that hard to do in an
application. You can write a stored procedure returns your blob data in a
result set and then assign that data to the appropriate datatype in your
application. But, to be honest, I think you would be better off to store the
data externally in a file system and then use the database to store the path
to the file. Your queries would be faster and your database size would be
much smaller and manageble. This lets the file system do what it does best
and the database server to what it does best.

Jim

"bsanders" <bsanders (AT) discussions (DOT) microsoft.com> wrote

Could you do something like this?

Write File Transformation
(http://www.sqldts.com/default.aspx?294)



"bsanders" <bsanders (AT) discussions (DOT) microsoft.com> wrote