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 binary data from MSDE

Author  Topic  rewo Starting Member 2 Posts Posted - 2006-08-25 : 15:59:55 Hi Im having a problem with a database getting full and would like to export a column with binary data. The binary data belongs to different types of files (pictures, txt-files etc) attached to tickets in an error reporting system. We would like to create a directory named as the issue ID and dump the file(s) corresponding to the issue there. For example C:\23-1005\Errormessage.txt The database is called MSDE (some kind of SQL light.. ?). Is there a simple way of doing this? Rewo