Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting BLOB from SQL

Author  Topic 

here4real
Starting Member

1 Post

Posted - 2004-11-09 : 13:21:15
I have imagess saved in BLOB fields that I need to export. Filenames, sizes, paths, etc. are saved as well. The physical files got clobbered and backups were not good (which is why I am attempting to get the image back from the BLOB). I'm not an SQL guru but can sure use some assistance here. I tried using DTS transformation and Write File from the BLOB to the filename stored on the record. It did write files but they seem too small and will not open.

Thanks.
   

- Advertisement -