Home Forums SQL Server 2005 SQL Server 2005 Integration Services Convert BLOB to TEXT RE: Convert BLOB to TEXT
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 14, 2008 at 4:33 pm
#789927
Try building a view over this table. In the select statement for the view, do this for the image field:
cast(image_field as nvarchar(max))
And then use the view as your data source for the transfer to a file.
😎