Can anyone get me pointed in the right direction or even better specific instructions on how to export BLOB's to .JPG's ? They are in SQL 2005 and I have about 1500 that I need to export. I ran across another site that said to use SSIS but I havent had much luck.
I am assuming that by exporting you mean "save as a file"
You can use the method shown in the following sample to create a bitmap from the blob in the database and then use the save method of the bitmap object to save it as an image in the desired format.
http://www.ftponline.com/vsm/2002_07/online/hottips/esposito/
sql
No comments:
Post a Comment