Export table data with BLOB column in CSV file


  • Hi,

    I want to export data  of a table into a flat file. I am using SQL Server Management Studio Export Data option. One of the column type is image (BLOB) in the table I want to export to a CSV file. The data inside that BLOB type column is text (an XML). The Data Export Wizard fails giving below error 

    The data type for "input column "BLOB_REQUEST" (84)" is DT_IMAGE, which is not supported. Use DT_TEXT or DT_NTEXT instead and convert the data from, or to, DT_IMAGE using the data conversion component.
     (SQL Server Import and Export Wizard)

    I went back and used Edit Transformation option, I changed destination type to textstream DT_TEXT but it still failed with same error.

    Kindly help how to export table data with BLOB/image column to flat CSV file?

    Best Regards!



    Wednesday, May 23, 2012 4:57 AM